<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:10pt"><div style="font-family: times new roman,new york,times,serif; font-size: 10pt;"><font size="3">Here are a list of my table definitions:<br><br></font><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: Mark Cave-Ayland <mark.cave-ayland@ilande.co.uk><br>To: PostGIS Users Discussion <postgis-users@postgis.refractions.net><br>Sent: Thursday, 26 July, 2007 10:44:58 AM<br>Subject: Re: [postgis-users] Performance Help<br><br><div>On Thu, 2007-07-26 at 02:04 +0000, Alan Cunnane wrote:<br>> Hi guys <br>> <br>> I have a query here that joins about 10 tables tables and uses two<br>> distance queries. Im am having massive performance issues with it and<br>> im hoping you could help me to tune it or change it
so that<br>> performance is increased. All of the columns being used for the joins<br>> have indexes and I have performed ANALYZE and VACUUM on each table.<br>> The query is as follows:<br><br>(rather complex query cut)<br><br>> As you can see it is taking entirely too much time for a query of this<br>> size in my opinion. Therefore im assuming I have done something wrong<br>> or could improve it in some way. I would really appreciate your help.<br>> <br>> Sincerely<br>> <br>> Alan<br><br><br>Hi Alan.<br><br>In order to help, we're going to need your table definitions and an<br>explanation of what your query is actually trying to in terms of<br>locating stops within certain times etc.<br><br><br>Kind regards,<br><br>Mark.<br><br>-- <br>ILande - Open Source Consultancy<br><a target="_blank" href="http://www.ilande.co.uk">http://www.ilande.co.uk</a><br><br><br>_______________________________________________<br>postgis-users
mailing list<br>postgis-users@postgis.refractions.net<br><a target="_blank" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></div></div><br></div></div><br>
<hr size=1>
Yahoo! Answers - Get better answers from someone who knows. <a
href="http://uk.answers.yahoo.com/;_ylc=X3oDMTEydmViNG02BF9TAzIxMTQ3MTcxOTAEc2VjA21haWwEc2xrA3RhZ2xpbmU">Try
it now</a>.</body></html>