Re: strange select issue

¿What happens if you run the same select from pgAdmin or psql?

On Thu, May 27, 2010 at 16:46, Kevin Kempter <kevink(at)consistentstate(dot)com>wrote:

> Hi All;
>
> We have a local postgres database (8.3.x) with an application / web front
> end
> pulling data from it. THe database server is on the east coast, we also
> have
> a remote application server in the UK.
>
> We can run a select from one of our configuration/meta-data databases (via
> the
> app) locally and it takes a few minutes but nothing alarming. However when
> we
> select the same data set from the UK app server it takes several hours. We
> did have SSL connections configured on the db server, we've turned SSL off
> and now the select from the UK app is faster but still takes about an hour.
> We can scp data from the db server to the UK server (via Linux moving a
> flat
> file) in a few seconds.
>
> Anyone have any thoughts per how to debug this?
>
> Thanks in advance
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support
>