Postgres Pro
Downloads
Home   >   mailing lists

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 8F4C99C66D04D4118F580090272A7A23018BFF@SECTORBASE1
Whole thread Raw
In response to Use of index in 7.0 vs 6.5  (Ryan Bradetich <ryan_bradetich@hp.com>)
Responses Re: Use of index in 7.0 vs 6.5
List pgsql-sql
Tree view 
> For example we could count up distinct values for the first 
> column of an index by scanning its index relation.

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...

Vadim

pgsql-sql by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Use of index in 7.0 vs 6.5
Next
From: Tom Lane
Date:
Subject: Re: Use of index in 7.0 vs 6.5