AW: RFC: planner statistics in 7.2 - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: RFC: planner statistics in 7.2
Date
Msg-id 11C1E6749A55D411A9670001FA68796336829C@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: RFC: planner statistics in 7.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> But you don't really need to look at the index (if it even exists
> at the time you do the ANALYZE).  The extent to which the data is
> ordered in the table is a property of the table, not the index.

Think compound, ascending, descending and functional index.
The (let's call it) cluster statistic for estimating indexscan cost can only 
be deduced from the index itself (for all but the simplest one column btree). 

Andreas


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: RFC: planner statistics in 7.2
Next
From: Tom Lane
Date:
Subject: Re: AW: RFC: planner statistics in 7.2