Re: VACUUM and transactions in different databases

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: VACUUM and transactions in different databases
Дата
Msg-id 16006.1165508910@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: VACUUM and transactions in different databases  (Bill Moran <wmoran@collaborativefusion.com>)
Ответы Re: VACUUM and transactions in different databases  (Ragnar <gnari@hive.is>)
Re: VACUUM and transactions in different databases  (Bill Moran <wmoran@collaborativefusion.com>)
Список pgsql-general
Bill Moran <wmoran@collaborativefusion.com> writes:
> In response to Alvaro Herrera <alvherre@commandprompt.com>:
>> Of course they are able to complete, but the point is that they would
>> not remove the tuples that would be visible to that idle open
>> transaction.

> I would expect that, but the OP claimed that vacuum full waited until
> the other transaction was finished.

No, she didn't claim that.  As far as I see she was just complaining
about the failure to remove dead tuples:

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

            regards, tom lane

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

Предыдущее
От: Zoltan Boszormenyi
Дата:
Сообщение: Re: Internal function call from C-language function
Следующее
От: Ragnar
Дата:
Сообщение: Re: VACUUM and transactions in different databases