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


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063



More information about the postgis-devel mailing list