Re: PATCH to allow concurrent VACUUMs to not lock each

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: PATCH to allow concurrent VACUUMs to not lock each
Дата
в 12:42:39
Msg-id
8215.1116862951@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
PATCH to allow concurrent VACUUMs to not lock each other out from cleaning old tuples Hannu Krosing <hannu@tm.ee>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@skype.net>
Re: PATCH to allow concurrent VACUUMs to not lock each other Bruce Momjian <pgman@candle.pha.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Neil Conway <neilc@samurai.com>
Re: PATCH to allow concurrent VACUUMs to not lock each Tom Lane <tgl@sss.pgh.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@skype.net>
Re: PATCH to allow concurrent VACUUMs to not lock each Tom Lane <tgl@sss.pgh.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@skype.net>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@skype.net>
Re: PATCH to allow concurrent VACUUMs to not lock each Bruce Momjian <bruce@momjian.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Alvaro Herrera <alvherre@commandprompt.com>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@skype.net>
Re: PATCH to allow concurrent VACUUMs to not lock each Alvaro Herrera <alvherre@commandprompt.com>
Re: PATCH to allow concurrent VACUUMs to not lock each Tom Lane <tgl@sss.pgh.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Alvaro Herrera <alvherre@commandprompt.com>
Re: PATCH to allow concurrent VACUUMs to not lock each Tom Lane <tgl@sss.pgh.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Tom Lane <tgl@sss.pgh.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@skype.net>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@tm.ee>
Re: PATCH to allow concurrent VACUUMs to not lock each Bruce Momjian <pgman@candle.pha.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@tm.ee>
Re: PATCH to allow concurrent VACUUMs to not lock each Bruce Momjian <pgman@candle.pha.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Tom Lane <tgl@sss.pgh.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Tom Lane <tgl@sss.pgh.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Hannu Krosing <hannu@skype.net>
Re: PATCH to allow concurrent VACUUMs to not lock each Bruce Momjian <pgman@candle.pha.pa.us>
Re: PATCH to allow concurrent VACUUMs to not lock each Bruce Momjian <pgman@candle.pha.pa.us>
Hannu Krosing  writes:
> I can't think of any other cases where it could matter, as at least the
> work done inside vacuum_rel() itself seema non-rollbackable.

VACUUM FULL's tuple-moving is definitely roll-back-able, so it might be
prudent to only do this for lazy VACUUM.  But on the other hand, VACUUM
FULL holds an exclusive lock on the table so no one else is going to see
its effects concurrently anyway.

As I said, it needs more thought than I've been able to spare for it yet
...

			regards, tom lane
В списке pgsql-patches по дате отправления
От: Hannu Krosing
Дата:
От: Hannu Krosing
Дата:
FAQ