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 8F4C99C66D04D4118F580090272A7A23018C05@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
> Yeah, a scan over just the index itself would be a perfect way to
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
I believe that Oracle updates index statistic on-fly...
Meta-page is always in cache for inserts, so there will be no
additional reads.

> gather stats.  The normal objection to it (can't tell whether entries
> correspond to currently-valid tuples) doesn't apply, because we don't
> really care whether the stats are perfectly accurate.

Vadim


pgsql-sql by date:

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