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 ED2C59FB21B for ; Thu, 13 Jul 2006 13:20:30 -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 17218-05 for ; Thu, 13 Jul 2006 13:20:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id C92D69FB1DC for ; Thu, 13 Jul 2006 13:20:26 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k6DGKPuE058304 for ; Thu, 13 Jul 2006 13:20:25 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k6DG41qW055066 for pgsql-admin@postgresql.org; Thu, 13 Jul 2006 13:04:01 -0300 (ADT) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: Where are the temporary work / sort files please Date: Thu, 13 Jul 2006 11:34:43 -0400 Organization: cbbrowne Computing Inc Lines: 14 Message-ID: <60d5c9r018.fsf@dba2.int.libertyrms.com> References: <1c66bda80607122114w2b981f22p44a1ad2ab6fa0e32@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:q3remsV2Li1uWKKr1Wqawh7RIro= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/89 X-Sequence-Number: 22335 adey11@gmail.com (adey) writes: > ...but I can't find pgsql_tmp in my v8.1.4 installation. > > Where can I find these temp files please? They get created on demand, and go away when that demand disappears. Run a big REINDEX and you'll see them pop into place... -- output = ("cbbrowne" "@" "ntlug.org") http://cbbrowne.com/info/sap.html "...Roxanne falls in love with Christian, a chevalier in Cyrano's regiment who hasn't got the brains God gave an eclair..." -- reviewer on NPR