[postgis-users] ST_SPHEROID_LENGTH SLOW

[Mark Cave-Ayland]

David Vaz wrote:
> I am unable to find any significant difference in the configurations,
> and the 2 datasets are in fact equal. It might be a slight difference in
> the configuration or even in compilation of postgres, but I am no expert
> in this so I need some help. I have attached both configuration and
> output of 'SHOW ALL'. I hope someone can give light on this subject. To
> me it seems the problem is on the Postgres side as you pointed out.

Hi David,

If the two configurations are equal, I wouldn't expect too much 
difference between the installations. The key part really is related to 
the vacuuming; 8.3 vacuum is known to eliminate some vacuum starvation 
cases, but this seems to be the opposite to what you are seeing.

Have you tried a pg_dump/re-initdb/pg_restore cycle on your 8.3 
installation? If the problem turns out to be either corruption or 
table/index bloat then this should immediately resolve it. Also just to 
confirm - where are you getting your debian packages from?


HTH,

Mark.

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