¿What happens if you run the same select from pgAdmin or psql? On Thu, May 27, 2010 at 16:46, Kevin Kempter <kev...@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 >
