> > 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
- Re: [SQL] Use of index in 7.0 vs 6.5 Ryan Bradetich
- Re: [SQL] Use of index in 7.0 vs 6.5 Tom Lane
- Re: [SQL] Use of index in 7.0 vs 6.5 Ryan Bradetich
- Re: [SQL] Use of index in 7.0 vs 6.5 Jeff Hoffmann
- Re: [SQL] Use of index in 7.0 vs 6.5 Tom Lane
- RE: [SQL] Use of index in 7.0 vs 6.5 Mikheev, Vadim
- Re: [SQL] Use of index in 7.0 vs 6.5 Bruce Momjian
- Re: [SQL] Use of index in 7.0 vs 6.5 Tom Lane
- Re: [SQL] Use of index in 7.0 vs 6.5 Bruce Momjian
- RE: [SQL] Use of index in 7.0 vs 6.5 Hiroshi Inoue
- RE: [SQL] Use of index in 7.0 vs 6.5 Mikheev, Vadim
- RE: [SQL] Use of index in 7.0 vs 6.5 Mikheev, Vadim