Обсуждение: strange select issue
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
¿What happens if you run the same select from pgAdmin or psql?
On Thu, May 27, 2010 at 16:46, Kevin Kempter <kevink@consistentstate.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support