Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 20F379F9C35 for ; Thu, 7 Dec 2006 13:03:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 22511-08 for ; Thu, 7 Dec 2006 13:03:00 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 1A4519F9386 for ; Thu, 7 Dec 2006 13:02:59 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id kB7H2wxO016389; Thu, 7 Dec 2006 12:02:59 -0500 (EST) To: Bill Moran cc: pgsql-performance@postgresql.org Subject: Re: Advice on selecting good values for work_mem? In-reply-to: <20061207113531.98095b27.wmoran@collaborativefusion.com> References: <20061207113531.98095b27.wmoran@collaborativefusion.com> Comments: In-reply-to Bill Moran message dated "Thu, 07 Dec 2006 11:35:31 -0500" Date: Thu, 07 Dec 2006 12:02:58 -0500 Message-ID: <16388.1165510978@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/180 X-Sequence-Number: 22236 Bill Moran 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. > That leads to my other question. Assuming I've got lots of > connections (which I do), how can I determine if work_mem is too > high? When you start swapping, you have a problem --- so watch vmstat or local equivalent. regards, tom lane