Postgres Pro
Downloads
Home   >   mailing lists

Re: AW: question about index cost estimates - Mailing list pgsql-hackers

From Tom Lane
Subject Re: AW: question about index cost estimates
Date
Msg-id 22427.958635641@sss.pgh.pa.us
Whole thread Raw
In response to AW: question about index cost estimates  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Responses Re: AW: question about index cost estimates  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
> Another metric that would be interesing is a number that represents 
> the divergence of the heap order from the index sort order.

Oh, absolutely!  Got any ideas about how to get that number in a
reasonable amount of time (not too much more than VACUUM takes now)?
I've been drawing a blank :-(
        regards, tom lane

pgsql-hackers by date:

Previous
From: Dave Page
Date:
Subject: RE: MSSQL7 & PostgreSQL 7.0
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: question about index cost estimates