Re: Advice on selecting good values for work_mem? - Mailing list pgsql-performance

From Bill Moran
Subject Re: Advice on selecting good values for work_mem?
Date
Msg-id 20061218161805.04699b10.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: Advice on selecting good values for work_mem?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Advice on selecting good values for work_mem?
List pgsql-performance
In response to Tom Lane <tgl@sss.pgh.pa.us>:

> Bill Moran <wmoran@collaborativefusion.com> writes:
> > Does the creation of a temp file trigger any logging?
>
> No; but it wouldn't be hard to add some if you wanted.  I'd do it at
> deletion, not creation, so you could log the size the file reached.
> See FileClose() in src/backend/storage/file/fd.c.

Is this along the lines of what you were thinking?  Is this acceptable
to get pulled into the tree (maintaining local patches sucks ;)  I've
only been using this patch a day and I'm already giddy about how much
it helps tuning work memory sizes ...

--
Bill Moran
Collaborative Fusion Inc.

Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Insertion to temp table deteriorating over time
Next
From: Bill Moran
Date:
Subject: Re: Advice on selecting good values for work_mem?