Re: maintenance_work_mem and autovacuum

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: maintenance_work_mem and autovacuum
Дата
Msg-id 49CC0D6E.2030407@agliodbs.com
обсуждение исходный текст
Ответ на Re: maintenance_work_mem and autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On 3/26/09 4:10 PM, Tom Lane wrote:
> Simon Riggs<simon@2ndQuadrant.com>  writes:
>> On Thu, 2009-03-26 at 13:43 -0700, Josh Berkus wrote:
>>> That said, it would be unnecessary if I could use ROLES to set
>>> parameters more reliably ....
>
>> Hmmm, perhaps the right way to do this is to have a user called
>> "autovacuum" that is used to perform autovacuums.
>
> Interesting idea, but maybe we should wait on it until we see what
> (if any) changes we are going to put into the relationship between
> roles and parameters.  Josh seems not to be happy with that ...

Well, it would work at present for this, because it's a login role, 
presumably.

--Josh



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: maintenance_work_mem and autovacuum
Следующее
От: Bernd Helmle
Дата:
Сообщение: Error message and infinite date and timestamp conversion in XML