Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?
Дата
Msg-id dcc563d10801200532o4bc1d075w1dff8d68c9e04ffd@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On Jan 20, 2008 6:44 AM, Martijn van Oosterhout <kleptog@svana.org> wrote:
> On Sun, Jan 20, 2008 at 09:29:16AM -0200, Clodoaldo wrote:
> > Will "enable_hashagg" be settable(*) per query or only at server start/reload?
>
> The enable_* settings are per session, so you can disable hashagg just
> before the query and reenable it just after, or disable it for just
> that process/user/database whatever you like.
>
> I think  the word you're looking for is "configurable".

And don't forget

alter {user|database} xyz set enable_hashagg={on|off};

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?
Следующее
От: Niederland
Дата:
Сообщение: postgresql 8.3rc1 on vista