Re: Automatically setting work_mem

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Automatically setting work_mem
Дата
Msg-id 9732.1142626694@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Automatically setting work_mem  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Automatically setting work_mem  ("Luke Lonergan" <llonergan@greenplum.com>)
Список pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
> Mind you, I'm also thinking that on enterprise installations with 
> multi-department use of the database, the fact that work_mem is 
> inalienably USERSET is also an allocation problem.   One user with a SET 
> command can blow all of your resource planning away.

One user with ability to enter arbitrary SQL commands can *always* blow
your resource planning away.  Blaming such things on work_mem is
seriously misguided.
        regards, tom lane


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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Automatically setting work_mem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Seperate command-line histories for seperate databases