Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 6B4F61337B5C for ; Thu, 16 Sep 2010 22:35:21 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 35761-07 for ; Fri, 17 Sep 2010 01:35:16 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 1ED231335B36 for ; Thu, 16 Sep 2010 22:35:13 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o8H1ZCgc013239; Thu, 16 Sep 2010 21:35:12 -0400 (EDT) To: donghe@caltech.edu cc: pgsql-admin@postgresql.org Subject: Re: issue pgsql_tmp keeps increasing In-reply-to: <2064.131.215.15.78.1284686446.squirrel@webmail.caltech.edu> References: <09B23E7BF70425478C1330D893A722C602FEC01A2C@MailSVR.invera.com> <2064.131.215.15.78.1284686446.squirrel@webmail.caltech.edu> Comments: In-reply-to donghe@caltech.edu message dated "Thu, 16 Sep 2010 18:20:46 -0700" Date: Thu, 16 Sep 2010 21:35:12 -0400 Message-ID: <13238.1284687312@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201009/97 X-Sequence-Number: 35641 donghe@caltech.edu writes: > I use psql (PostgreSQL) 8.1.10 on my box, there is a postmater process > running automatically to make temp files in pgsql_tmp folder, I don't do > any query on my database. Anybody knows what's wrong with it? and how to > find what the postmater process is for Look in pg_stat_activity, perhaps. In 8.1 that won't show you the actual command unless you changed some default settings, but it should at least tell you when the command was started and by whom. regards, tom lane