Re: strange select issue

¿What happens if you run the same select from pgAdmin or psql?<br /><br /><div class="gmail_quote">On Thu, May 27, 2010
at16:46, Kevin Kempter <span dir="ltr"><<a
href="mailto:kevink@consistentstate.com">kevink@consistentstate.com</a>></span>wrote:<br /><blockquote
class="gmail_quote"style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi
All;<br/><br /> We have a local postgres database (8.3.x) with an application / web front end<br /> pulling data from
it. THe database server is on the east coast, we also have<br /> a remote application server in the UK.<br /><br /> We
canrun a select from one of our configuration/meta-data databases (via the<br /> app) locally and it takes a few
minutesbut nothing alarming. However when we<br /> select the same data set from the UK app server it takes several
hours. We<br /> did have SSL connections configured on the db server, we've turned SSL off<br /> and now the select
fromthe UK app is faster but still takes about an hour.<br /> We can scp data from the db server to the UK server (via
Linuxmoving a flat<br /> file) in a few seconds.<br /><br /> Anyone have any thoughts per how to debug this?<br /><br
/>Thanks in advance<br /><font color="#888888"><br /> --<br /> Sent via pgadmin-support mailing list (<a
href="mailto:pgadmin-support@postgresql.org">pgadmin-support@postgresql.org</a>)<br/> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgadmin-support"
target="_blank">http://www.postgresql.org/mailpref/pgadmin-support</a><br/></font></blockquote></div><br />