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

[Ethan Alpert]

Although when I first posted I hadn't run update_geometry_stats() (I'm
using 7.4.6) I do have that in a nightly cron job.

I just reran my query with the same time results so it appears to have
had no affect.

-e
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mark
Cave-Ayland
Sent: Thursday, September 08, 2005 3:21 PM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] Why does this take almost 3 hours?


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


_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users