Re: Remote access to Postgresql slow - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Remote access to Postgresql slow
Date
Msg-id CAOR=d=0s4m9rrE_+QCJMhRgYpW3SNBatConTihFPdEXJOcnReA@mail.gmail.com
Whole thread Raw
In response to Remote access to Postgresql slow  ("Manoj Agarwal" <ma@ockham.be>)
List pgsql-performance
On Fri, Sep 14, 2012 at 3:02 AM, Manoj Agarwal <ma@ockham.be> wrote:
> changed.  The connection is all fine and the application can access the
> remote database.
>
> I have observed that the Postgresql is responding extremely slow.  What
> should I do to improve its performance?

Are you connecting via host name?  If so have you tried connecting via IP?


pgsql-performance by date:

Previous
From: Andrew Barnham
Date:
Subject: Re: Remote access to Postgresql slow
Next
From: Craig Ringer
Date:
Subject: Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate