<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Andale Mono";
panose-1:2 11 5 9 0 0 0 0 0 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:#606420;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Andale Mono";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink="#606420">
<div class=Section1>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>Hey all,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>I currently am working on a PostGIS database
(Postgres 8.3) and the requests are going slower than expected.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>The table I’m querying off of has ~42000
entries in it, and the geometry field I’m using has a gist index on it.
The query however is taking ~6 seconds to return me the entries.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>I am making the query <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face="Andale Mono"><span
style='font-size:10.0pt;font-family:"Andale Mono"'>SELECT * FROM
asdfs_track_point where within(the_geom,GeometryFromText('POLYGON((-180.0
-90.0,-180.0 90.0,180.0 90.0,180.0 -90.0,-180.0 -90.0))',4326));<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-indent:.5in'><font size=2 face="Andale Mono"><span
style='font-size:10.0pt;font-family:"Andale Mono"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>This is a test case and so I am doing the entire
world to find out how long things should take, but I’m told that with
only 42000 rows in the table it should be faster than 6 seconds.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>Anyone have any idea why it might be going slow, or
a way to speed up the query?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>- Brian Peck</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>- 858-795-1398</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>- Software Engineer</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 face="Andale Mono"><span style='font-size:10.0pt;
font-family:"Andale Mono"'>- Lockheed Martin</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>