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

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, PostgreSQL - General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?
Date: 2008-01-20 12:44:13
Message-ID: 20080120124413.GC9599@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-01-20 13:32:39 Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?
Previous Message Ivan Sergio Borgonovo 2008-01-20 12:10:39 planner and simple vs. complex statement was: example query for postgresql