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

From Martijn van Oosterhout
Subject Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?
Date
Msg-id 20080120124413.GC9599@svana.org
Whole thread Raw
In response to Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?  (Clodoaldo <clodoaldo.pinto.neto@gmail.com>)
Responses Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
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".

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Attachment

pgsql-general by date:

Previous
From: Ivan Sergio Borgonovo
Date:
Subject: planner and simple vs. complex statement was: example query for postgresql
Next
From: "Scott Marlowe"
Date:
Subject: Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?