> > 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 -:))
pgsql-sql by date
|Next:||From: Mikheev, Vadim||Date: 2000-05-25 17:17:41|
|Subject: RE: Use of index in 7.0 vs 6.5 |
|Previous:||From: Bruce Momjian||Date: 2000-05-25 16:08:45|
|Subject: Re: Use of index in 7.0 vs 6.5|