Re: database bloat,non removovable rows, slow query etc...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: database bloat,non removovable rows, slow query etc...
Дата
Msg-id 4027.1157121810@sss.pgh.pa.us
обсуждение исходный текст
Ответ на database bloat,non removovable rows, slow query etc...  (Matteo Sgalaberni <sgala@sgala.com>)
Ответы Re: database bloat,non removovable rows, slow query etc...  (Markus Schaber <schabi@logix-tt.com>)
Re: database bloat,non removovable rows, slow query etc...  (Matteo Sgalaberni <sgala@sgala.com>)
Список pgsql-performance
Matteo Sgalaberni <sgala@sgala.com> writes:
> 22 daemons that have a persistent connection to this database(all
> connection are in "idle"(no transaction opened).

You may think that, but you are wrong.

> INFO:  "cliente": found 0 removable, 29931 nonremovable row versions in 559 pages
> DETAIL:  29398 dead row versions cannot be removed yet.

The only way the above can happen is if there are some fairly old open
transactions.  Looking in pg_stat_activity might help you identify the
culprit(s).

            regards, tom lane

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

Предыдущее
От: Matteo Sgalaberni
Дата:
Сообщение: database bloat,non removovable rows, slow query etc...
Следующее
От: Patrick Hatcher
Дата:
Сообщение: Re: database bloat,non removovable rows, slow query etc...