[postgis-devel] CLUSTER in 8.3

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Fri Dec 5 09:34:30 PST 2008

Chris Hodgson wrote:
> It might be worth trying it on a non-Postgis index... if you can 
> replicate it using a the GiST B-tree implementation on a table full of 
> integers then I expect you could immediately get the attention of the 
> Postgres devs, or at least Oleg and/or Teodor.
> If you can't replicate it that way, it still doesn't rule it out as a 
> Postgresql core or GiST problem... but it certainly suggests that 
> Postgis does something differently that isn't helping.
> Chris

I think the GiST part is a red herring - there is no way that a "SELECT 
COUNT(*) FROM foo" can use an index in PostgreSQL. My suspicion is that 
it's related to the use of ANALYZE/VACUUM/CLUSTER.



Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
T: +44 870 608 0063

More information about the postgis-devel mailing list