VACUUM and transactions in different databases

Поиск
Список
Период
Сортировка
От Cornelia Boenigk
Тема VACUUM and transactions in different databases
Дата
Msg-id 45775103.1040001@cornelia-boenigk.de
обсуждение исходный текст
Ответы Re: VACUUM and transactions in different databases  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-general
Hi all

If I have a running transaction in database1 and try to vacuum database2
but the dead tuples in database2 cannot be removed.

INFO:  vacuuming "public.dummy1"
INFO:  "dummy1": found 0 removable, 140000 nonremovable row versions in
1341 pages
DETAIL:  135000 dead row versions cannot be removed yet.

How can I achieve that database2 is vacuumed while a transaction in
database1 is not yet commited?

Regards
conni

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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: Trying to Understand Table Inheritance
Следующее
От: Bill Moran
Дата:
Сообщение: Re: VACUUM and transactions in different databases