Re: vacuum by non-owner

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: vacuum by non-owner
Дата
Msg-id m3k7e6kle0.fsf@varsoon.wireboard.com
обсуждение исходный текст
Ответ на vacuum by non-owner  (Richard Stover <richard@ucolick.org>)
Список pgsql-general
Richard Stover <richard@ucolick.org> writes:

> Do I have to run a small program which is setuid to the owner
> of the tables in order to make it possible for the users to
> VACUUM the tables? Or is there a more elegant way to do this?

Why not run 'vacuumdb' periodically out of 'cron' as the postgres
user?

-Doug

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

Предыдущее
От: Jonathan Bartlett
Дата:
Сообщение: Re: Why no performance boost although I added an index?
Следующее
От: "Dan Langille"
Дата:
Сообщение: Re: Why no performance boost although I added an index?