X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7CA10D8A69 for ; Thu, 3 Nov 2005 22:54:50 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07112-02 for ; Fri, 4 Nov 2005 02:54:46 +0000 (GMT) X-Greylist: delayed 00:17:56.848173 by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.201]) by svr1.postgresql.org (Postfix) with ESMTP id 1461BD6817 for ; Thu, 3 Nov 2005 22:54:48 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i34so304003wra for ; Thu, 03 Nov 2005 18:54:51 -0800 (PST) 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:content-transfer-encoding:content-disposition; b=Vny9wAMxgiv+ZB204TZEKiJ9GI3LG+BQ+YdzGhJkEsj9Bpe5y2L4J34Teb4W/VdJwdUJNC9+lqkDKed52ewz2dkiMt6cndZaNoP0cD9Y+JTw+4kS2gXjTDt5KJ6lhj4j/sLPwCg3mFYHBnzSuW9eNVO9/pPq5+7tVoSmAxmuSxU= Received: by 10.65.147.10 with SMTP id z10mr1551691qbn; Thu, 03 Nov 2005 18:30:41 -0800 (PST) Received: by 10.65.83.10 with HTTP; Thu, 3 Nov 2005 18:30:41 -0800 (PST) Message-ID: <4f34febc0511031830w31e6f3d0mdd5470c801860052@mail.gmail.com> Date: Fri, 4 Nov 2005 11:30:41 +0900 From: John Barham To: pgsql-admin@postgresql.org Subject: Deleting old files from pgsql_tmp MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.116 required=5 tests=[AWL=0.116] X-Spam-Score: 0.116 X-Spam-Level: X-Archive-Number: 200511/38 X-Sequence-Number: 19411 Is it safe to delete old files created in pgsql_tmp? I ask because a rogue query created almost 800 GB of temporary files and I would like to reclaim that disk space. The query was killed (using kill -9 which I know is not the right thing to do...) so did not get the chance to clean up after itself. John Barham