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 575AF9FB1D8 for ; Thu, 13 Jul 2006 01:14:57 -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 11405-04 for ; Thu, 13 Jul 2006 01:14:52 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id 229349FB1B7 for ; Thu, 13 Jul 2006 01:14:52 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id m3so126036uge for ; Wed, 12 Jul 2006 21:14:51 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=eQ/OaEA5TgiYxg9NpAhSbvj4YviZtGtQoQoKKcayFBsQhFzy08tybTAblQ+tWn24QaHH7HtdZk6IFKqgJ+F2svWq4QZ3jmwq8Bp77Msf/ruLJHcuZ2HB2QeFzh26bIBwlVEUYUtkGhBHaCJXcMUfdPahZx9PoCPHTl2L0kZQ96g= Received: by 10.67.26.7 with SMTP id d7mr90090ugj; Wed, 12 Jul 2006 21:14:50 -0700 (PDT) Received: by 10.66.241.4 with HTTP; Wed, 12 Jul 2006 21:14:50 -0700 (PDT) Message-ID: <1c66bda80607122114w2b981f22p44a1ad2ab6fa0e32@mail.gmail.com> Date: Thu, 13 Jul 2006 16:14:50 +1200 From: adey To: "pgsql-admin@postgresql.org" , postgresql-l Subject: Where are the temporary work / sort files please MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3401_28517482.1152764090887" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/81 X-Sequence-Number: 22327 ------=_Part_3401_28517482.1152764090887 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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? ------=_Part_3401_28517482.1152764090887 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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?
 
------=_Part_3401_28517482.1152764090887--