RE: Use of index in 7.0 vs 6.5 - Mailing list pgsql-sql

From Mikheev, Vadim
Subject RE: Use of index in 7.0 vs 6.5
Date
Msg-id 8F4C99C66D04D4118F580090272A7A23018C02@SECTORBASE1
Whole thread Raw
In response to Use of index in 7.0 vs 6.5  (Ryan Bradetich <ryan_bradetich@hp.com>)
List pgsql-sql
> > 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


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Use of index in 7.0 vs 6.5
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: Use of index in 7.0 vs 6.5