Skip site navigation (1) Skip section navigation (2)

strange select issue

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: strange select issue
Date: 2010-05-27 19:46:43
Message-ID: 201005271346.43640.kevink@consistentstate.com (view raw or flat)
Thread:
Lists: pgadmin-support
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

Responses

pgadmin-support by date

Next:From: Fernando HeviaDate: 2010-05-28 00:13:15
Subject: Re: strange select issue
Previous:From: Thom BrownDate: 2010-05-26 08:22:44
Subject: Re: Netbeans6.0 with PostgreSQl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group