[postgis-users] Why does this take almost 3 hours?
m.cave-ayland at webbased.co.uk
Thu Sep 8 14:20:38 PDT 2005
> -----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?
> Ethan, would you run VACUUM ANALYZE and send explain output again ?
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).
17 Research Way
Tamar Science Park
T: +44 (0)1752 797131
F: +44 (0)1752 791023
More information about the postgis-users