Home > mailing lists

Re: setting configuration values inside a stored proc - Mailing list pgsql-performance

From	Samuel Gendler
Subject	Re: setting configuration values inside a stored proc
Date	May 13, 2011 09:42:06
Msg-id	BANLkTimr9pFDTvx8NgwYrmtE1E3Xmit1yA@mail.gmail.com Whole thread Raw
In response to	Re: setting configuration values inside a stored proc (Andres Freund <andres@anarazel.de>)
List	pgsql-performance

On Fri, May 13, 2011 at 1:28 AM, Andres Freund <andres@anarazel.de> wrote:

Hi,

On Friday, May 13, 2011 01:10:19 AM Samuel Gendler wrote:

I would suggest doing ALTER FUNCTION blub(blarg) SET work_mem = '512MB';

Ah! That's perfect and very convenient. Thanks.

--sam

From: tv@fuzzy.cz
Date: 13 May 2011, 08:44:56
Subject: Re: [ADMIN] since when has pg_stat_user_indexes.idx_scan been counting?

From: Fredrik Widlert
Date: 13 May 2011, 12:02:49
Subject: How to avoid seq scans for joins between union-all views (test case included)