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
Список 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 по дате отправления: