From: Andres Freund <andres@anarazel.de>
To: pgsql-performance@postgresql.org
Cc: Samuel Gendler <sgendler@ideasculptor.com>
Subject: Re: setting configuration values inside a stored proc
Date: Fri, 13 May 2011 10:28:15 +0200
Message-ID: <201105131028.15694.andres@anarazel.de> (raw)
In-Reply-To: <BANLkTimJjQREogk=pD+j6WT+yWEZtjfDWg@mail.gmail.com>
References: <BANLkTimJjQREogk=pD+j6WT+yWEZtjfDWg@mail.gmail.com>
Hi,
On Friday, May 13, 2011 01:10:19 AM Samuel Gendler wrote:
> I've got a stored proc that constructs some aggregation queries as strings
> and then executes them. I'd like to be able to increase work_mem before
> running those queries. If I set a new value for work_mem within the stored
> proc prior to executing my query string, will that actually have an impact
> on the query or is work_mem basically a constant once the outer statement
> that calls the stored proc has begun? I'd just test, but it will take
> hours for me to grab a copy of production data and import into a new db
> host for testing. I've already started that process, but I'm betting I'll
> have an answer by the time it completes. It's just the difference between
> modifying the application which calls the procs (and doing a full software
> release in order to do so or else waiting a month to go in the next
> release) vs modifying the procs themselves, which requires only db a
> update.
I would suggest doing ALTER FUNCTION blub(blarg) SET work_mem = '512MB';
Andres
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andres@anarazel.de, sgendler@ideasculptor.com
Subject: Re: setting configuration values inside a stored proc
In-Reply-To: <201105131028.15694.andres@anarazel.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox