From: | Fernando Hevia <fhevia(at)gmail(dot)com> |
---|---|
To: | Kevin Kempter <kevink(at)consistentstate(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: strange select issue |
Date: | 2010-05-28 00:13:15 |
Message-ID: | AANLkTimHX7uW8nYgeAiJr6A36xtshNgtZ5N5EbzLNlXf@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
¿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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2010-05-28 11:07:34 | Apparent bug in 1.10.3 - refreshing functions within the object browser causes them to disappear |
Previous Message | Kevin Kempter | 2010-05-27 19:46:43 | strange select issue |