X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A39739FB1DB for ; Thu, 13 Jul 2006 05:13:22 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 44178-04 for ; Thu, 13 Jul 2006 05:13:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id B89389FA7BA for ; Thu, 13 Jul 2006 05:13:12 -0300 (ADT) Received: from [213.146.143.243] (port=40492 helo=[172.16.208.156]) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1G0wJp-00083V-3u; Thu, 13 Jul 2006 09:13:09 +0100 Message-ID: <44B600E0.80802@andycc.net> Date: Thu, 13 Jul 2006 09:14:24 +0100 From: Andy Shellam User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: adey , pgsql-admin@postgresql.org Subject: Re: Where are the temporary work / sort files please References: <1c66bda80607122114w2b981f22p44a1ad2ab6fa0e32@mail.gmail.com> In-Reply-To: <1c66bda80607122114w2b981f22p44a1ad2ab6fa0e32@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/84 X-Sequence-Number: 22330 These do exist as the documentation says - I found them in my 8.1.3 install, but only for a couple of databases. Perhaps they're only used when there has a need to be swapping data to disk? adey wrote: > The postgresql parameter explanation for work_mem say :- > > "Another way to set this value is to monitor the Postgres temp files > (in PGDATA/base/DB_OID/pgsql_tmp) and adjust sort_mem > upward if you see a lot of queries swapping from these temp files." > > ...but I can't find pgsql_tmp in my v8.1.4 installation. > Where can I find these temp files please? > > !DSPAM:14,44b5cb6f34532045524622!