Re: Postgres connection status as BIND

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Postgres connection status as BIND
Дата
Msg-id 200906150808.01841@hal.medialogik.com
обсуждение исходный текст
Ответ на Postgres connection status as BIND  (Nimesh Satam <nimesh.zedo@gmail.com>)
Список pgsql-performance
On Monday 15 June 2009, Nimesh Satam <nimesh.zedo@gmail.com> wrote:
> Hi,
>
> When we do a ps U postgres command, we find some connection in BIND
> status:
>
> 10088 ?        Ss     0:00 postgres: chk production xxx.xx.x.xx(48672)
> BIND 10090 ?        Ss     0:00 postgres: chk production
> xxx.xx.x.xx(48674) BIND
>
>
> We are connecting to the database using pgpool for load balancing and
> slony for replication. Postgres version - 8.3.3.

pgpool does that on some connections on some of my servers (but not others).
I haven't been able to figure out why.


--
WARNING:  Do not look into laser with remaining eye.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres connection status as BIND
Следующее
От: Alexander Staubo
Дата:
Сообщение: Yet another slow nested loop