Re: [ADMIN] (auto) vacuum mysterious

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: [ADMIN] (auto) vacuum mysterious
Дата
Msg-id 20170214145255.7v3x64l22h4sylck@alvherre.pgsql
обсуждение исходный текст
Ответ на [ADMIN] (auto) vacuum mysterious  (<walpino@gmail.com>)
Список pgsql-admin
walpino@gmail.com wrote:
> Hi There
>
> My Name is Martin
> And we are running PostgreSQL 9.5.3
>
> We are doing a lot of deletes updates and Inserts on some tables
>
> Until now we didn’t Encounter so much Problems with the vacuumizer but in the last view days we have the fact the
vacuumcannot remove dead rows anymore 
>
> I know it is the case when there are other Long running Transactions running but this isn’t the case

Maybe you have an inactive replication slot.  See
  select * from pg_replication_slots;
and consider dropping those that are unused.

--
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Feike Steenbergen
Дата:
Сообщение: Re: [ADMIN] Req. for some help with temp tables
Следующее
От: Thorsten Schöning
Дата:
Сообщение: [ADMIN] Questions regarding PL/Perl