[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 Ethan Alpert
> Sent: 08 September 2005 23:03
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] Why does this take almost 3 hours?
> 
> 
> 
> 
> 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


Hi Ethan,

And can you confirm the version of PostGIS you are using (the output from
SELECT postgis_version()?). Both of these are really important when trying
to work out why bad query plans have been chosen.


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