[postgis-users] Why does this take almost 3 hours?

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of strk at refractions.net
> Sent: 08 September 2005 18:37
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Why does this take almost 3 hours?

(cut)

> Ethan, would you run VACUUM ANALYZE and send explain output again ?
> 
> --strk;


Hi Ethan,

Can you confirm which version of PostgreSQL/PostGIS you are using, i.e. the
output of SELECT version() and SELECT postgis_version()?

If you are using PostgreSQL < 8.0 then you need to do SELECT
update_geometry_stats() in order to build the statistics for the geometry
columns to help the planner choose the correct index (in 8.0 and later this
is done as part of VACUUM ANALYZE).


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Tamar Science Park
Plymouth
PL6 8BT 

T: +44 (0)1752 797131
F: +44 (0)1752 791023
W: http://www.webbased.co.uk