Received: from sectorbase2.sectorbase.com ([208.48.122.131]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA74893 for ; Thu, 25 May 2000 10:35:17 -0400 (EDT) (envelope-from vmikheev@SECTORBASE.COM) Received: by SECTORBASE2 with Internet Mail Service (5.5.2650.21) id ; Thu, 25 May 2000 07:28:36 -0700 Message-ID: <8F4C99C66D04D4118F580090272A7A23018BFF@SECTORBASE1> From: "Mikheev, Vadim" To: "'Hiroshi Inoue'" , Tom Lane Cc: Ryan Bradetich , pgsql-sql@postgresql.org Subject: RE: Use of index in 7.0 vs 6.5 Date: Thu, 25 May 2000 07:29:58 -0700 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200005/139 > For example we could count up distinct values for the first > column of an index by scanning its index relation. Oracle has index keys distribution page... And we have near empty meta-page for each index AM... And backend reads this page for each insert... Vadim