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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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