Re: Remote access to Postgresql slow

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Remote access to Postgresql slow
Дата
Msg-id CAOR=d=0s4m9rrE_+QCJMhRgYpW3SNBatConTihFPdEXJOcnReA@mail.gmail.com
обсуждение исходный текст
Ответ на Remote access to Postgresql slow  ("Manoj Agarwal" <ma@ockham.be>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Barnham
Дата:
Сообщение: Re: Remote access to Postgresql slow
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate