Skip site navigation (1) Skip section navigation (2)

RE: Use of index in 7.0 vs 6.5

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'Bruce Momjian'" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ryan Bradetich <ryan_bradetich(at)hp(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: RE: Use of index in 7.0 vs 6.5
Date: 2000-05-25 16:12:32
Message-ID: 8F4C99C66D04D4118F580090272A7A23018C02@SECTORBASE1 (view raw or flat)
Thread:
Lists: 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

Next:From: Mikheev, VadimDate: 2000-05-25 17:17:41
Subject: RE: Use of index in 7.0 vs 6.5
Previous:From: Bruce MomjianDate: 2000-05-25 16:08:45
Subject: Re: Use of index in 7.0 vs 6.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group