Skip site navigation (1) Skip section navigation (2)

Re: patch review : Add ability to constrain backend temporary file space

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: patch review : Add ability to constrain backend temporary file space
Date: 2011-06-01 00:46:18
Message-ID: 4DE58BDA.9010102@catalyst.net.nz (view raw or flat)
Thread:
Lists: pgsql-hackers
On 01/06/11 12:32, Mark Kirkwood wrote:
> On 01/06/11 12:27, Mark Kirkwood wrote:
>>
>> Re the code comments - I agree with most of them. However with 
>> respect to the Guc units, I copied the setup for work_mem as that 
>> seemed the most related.
>
> Also - forget to mention - I *thought* you could specify the temp 
> files size GUC as KB, MB, GB or plain old pages, but I'll check this, 
> in case I've busted it somehow.
>

Doh, ignore me here :-( You are correct - I've specified GUC_UNITS_KB 
(copying work_mem) - it is easy enough to allow pages like shared_buffers.

Cheers

Mark

In response to

pgsql-hackers by date

Next:From: Robert HaasDate: 2011-06-01 00:55:38
Subject: Re: [PERFORM] Hash Anti Join performance degradation
Previous:From: Cédric VillemainDate: 2011-06-01 00:43:05
Subject: Re: [PERFORM] Hash Anti Join performance degradation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group