From: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | how do I get rid of huge sorttemp files? |
Date: | 2003-06-16 15:55:03 |
Message-ID: | 1055778903.2212.5.camel@fluor |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
[root(at)ds80-237-200-79 6221984]# pwd
/var/lib/pgsql/data/base/6221984
[root(at)ds80-237-200-79 6221984]# ls -lh --sort=size | head -10
total 9.9G
-rw------- 1 postgres postgres 1.0G Jan 7 12:36
pg_sorttemp10742.0
-rw------- 1 postgres postgres 1.0G Jan 7 12:36
pg_sorttemp10749.0
-rw------- 1 postgres postgres 1.0G Jan 7 12:36
pg_sorttemp10771.0
-rw------- 1 postgres postgres 1.0G Jan 7 12:36
pg_sorttemp10795.0
-rw------- 1 postgres postgres 1.0G Jan 8 17:13
pg_sorttemp3029.0
-rw------- 1 postgres postgres 779M Jan 4 11:39
pg_sorttemp10464.0
-rw------- 1 postgres postgres 599M Jan 7 16:56
pg_sorttemp12913.0
-rw------- 1 postgres postgres 515M Jan 9 17:44
pg_sorttemp2457.0
-rw------- 1 postgres postgres 349M Jan 7 12:36
pg_sorttemp10742.1
template1=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
How do I get rid of these huge files and how do I prevent them from
being created again? The dump of the whole database is ~50 Megabytes
gzipped.
Thanks
--
Markus Bertheau
Cenes Data GmbH
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-06-16 16:04:10 | Re: psql sequence question |
Previous Message | Raj Mathur | 2003-06-16 15:54:10 | Re: Move passwords between databases |