Received: from sectorbase2.sectorbase.com ([208.48.122.131]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA95616 for ; Thu, 25 May 2000 12:17:38 -0400 (EDT) (envelope-from vmikheev@SECTORBASE.COM) Received: by SECTORBASE2 with Internet Mail Service (5.5.2650.21) id ; Thu, 25 May 2000 09:11:08 -0700 Message-ID: <8F4C99C66D04D4118F580090272A7A23018C02@SECTORBASE1> From: "Mikheev, Vadim" To: "'Bruce Momjian'" Cc: "'Hiroshi Inoue'" , Tom Lane , Ryan Bradetich , pgsql-sql@postgresql.org Subject: RE: Use of index in 7.0 vs 6.5 Date: Thu, 25 May 2000 09:12:32 -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/146 > > 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... > > That certainly would make sense. We have hesitated to gather more > statistics because of the time involved. Fuller statistics > on just the > indexed columns could be a big win and be done fairly quickly because > the rows are already sorted in the index. So, add new item to TODO -:) (I'm sure that I've told about index keys distribution page already - I become tired to say about the same more and more -:)) Vadim