[postgis-users] Performance Help

Alan Cunnane alan_cunnane at yahoo.co.uk
Thu Jul 26 06:52:02 PDT 2007

By stored procedures what do you mean exactly? Do you mean in a Perl script or something similar?

----- 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 2:47:27 PM
Subject: Re: [postgis-users] Performance Help

On Thu, 2007-07-26 at 11:51 +0000, Alan Cunnane wrote:
> I have actually already looked at PG routing however because of the
> constraints of this particular project I cannot use it. I have to use
> SQL queries as I was attempting however it seems that the query runs
> smoothly enough up until the 8th or 9th table is added to the join. Is
> this my own fault in the query or is this just the performance of
> Postgresql in handling a large number of joins? I do appreciate your
> help and advice,
> Alan

Tricky :(

I guess the only thing you can do in that case is check the query plans
just before and just after the point at which the query plan
deteriorates and try and spot the difference.

Are you allowed to use stored procedures for your solution? Due to the
recursive-type nature of some of the queries you will need, it may be
possible to come up with something more efficient that way.



ILande - Open Source Consultancy

postgis-users mailing list
postgis-users at postgis.refractions.net

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/3e253d33/attachment.html>

More information about the postgis-users mailing list