Re: Feedback on getting rid of VACUUM FULL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Feedback on getting rid of VACUUM FULL
Дата
Msg-id 3409.1253147817@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Feedback on getting rid of VACUUM FULL  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: Feedback on getting rid of VACUUM FULL  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> writes:
> For the kicks, I looked at what it would take to write a utility like
> that. It turns out to be quite trivial, patch attached.

I don't think you've really thought this through; particularly not this:

> +    rel = heap_open(relid, AccessShareLock);

You can NOT modify a relation with only AccessShareLock, and frankly
I doubt you should be doing this with less than exclusive lock.  Which
would make the thing quite unpleasant to use in practice.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PATCH: make plpgsql IN args mutable (v1) [REVIEW]
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: [PATCH] pgbench: new feature allowing to launch shell commands