[postgis-users] Why does this take almost 3 hours?
m.cave-ayland at webbased.co.uk
Fri Sep 9 00:31:37 PDT 2005
> -----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.
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.
17 Research Way
Tamar Science Park
T: +44 (0)1752 797131
F: +44 (0)1752 791023
More information about the postgis-users