[postgis-users] Performance Help

[Alan Cunnane]

Here are a list of my table definitions:


----- Original Message ----
From: Mark Cave-Ayland <mark.cave-ayland at ilande.co.uk>
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Sent: Thursday, 26 July, 2007 10:44:58 AM
Subject: Re: [postgis-users] Performance Help

On Thu, 2007-07-26 at 02:04 +0000, Alan Cunnane wrote:
> Hi guys 
> 
> I have a query here that joins about 10 tables tables and uses two
> distance queries. Im am having massive performance issues with it and
> im hoping you could help me to tune it or change it so that
> performance is increased. All of the columns being used for the joins
> have indexes and I have performed ANALYZE and VACUUM on each table.
> The query is as follows:

(rather complex query cut)

> As you can see it is taking entirely too much time for a query of this
> size in my opinion. Therefore im assuming I have done something wrong
> or could improve it in some way. I would really appreciate your help.
> 
> Sincerely
> 
> Alan


Hi Alan.

In order to help, we're going to need your table definitions and an
explanation of what your query is actually trying to in terms of
locating stops within certain times etc.


Kind regards,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk


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







      ___________________________________________________________ 
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070726/81376dd3/attachment.html>