Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k6FHN-0008GO-6O for pgsql-admin@arkaria.postgresql.org; Thu, 13 Aug 2020 15:36:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k6FHL-0002X2-C0 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Aug 2020 15:36:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k6FHL-0002Wu-4W for pgsql-admin@lists.postgresql.org; Thu, 13 Aug 2020 15:36:31 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k6FHG-0006p6-TO for pgsql-admin@postgresql.org; Thu, 13 Aug 2020 15:36:30 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id 603D22057C032 for ; Thu, 13 Aug 2020 08:36:24 -0700 (MST) Date: Thu, 13 Aug 2020 08:36:24 -0700 (MST) From: legrand legrand To: pgsql-admin@postgresql.org Message-ID: <1597332984344-0.post@n3.nabble.com> In-Reply-To: References: Subject: Re: Postgres vs Oracle MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, This will be very difficult to answer without additional informations ...= =20 first index size on oracle, is bigger than table size, that Could be sign of an over indexed table ... 1/ could you provide the indexes d=C3=A9finition (index type, Columns, Column type) from oracle 2/ same for pg 3/ informations about data distribution, like number of keys, Number of Distinct values... Regards PAscal -- Sent from: https://www.postgresql-archive.org/PostgreSQL-admin-f2076596.htm= l