Re: Vacuum not cleaning up rows.

Поиск
Список
Период
Сортировка
От SBob
Тема Re: Vacuum not cleaning up rows.
Дата
Msg-id ef2d3985-cbb4-4d42-a06a-0c8163dc85a7@www.fastmail.com
обсуждение исходный текст
Ответ на Re: Vacuum not cleaning up rows.  (Rui DeSousa <rui@crazybean.net>)
Ответы Re: Vacuum not cleaning up rows.
Список pgsql-admin
I do see older backend_start values (from around 6 hours ago). However I am confused as to how a connection to one database in a cluster can prevenr vacuum from cleaning up row versions in a table within another database.   How is that possible since onle one database has access to this table?



On Thu, Jun 20, 2019, at 2:37 PM, Rui DeSousa wrote:

In addition to what others have already stated to check; also check for replication slots.


select * from pg_replication_slots;


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

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: Vacuum not cleaning up rows.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Vacuum not cleaning up rows.