Re: [GENERAL] pg_psort files

On Tue, 14 Dec 1999, Steven Saner wrote:

> I have a fairly simple database (two tables and a few indecies). In
> the data/base/xxxx directory I find the following files:
>
> -rw------- 1 postgres postgres 7734146 Dec 14 06:36 pg_psort.13268.0
> -rw------- 1 postgres postgres 7707487 Dec 14 06:36 pg_psort.13268.1
> -rw------- 1 postgres postgres 7776602 Dec 14 06:36 pg_psort.13268.2
> -rw------- 1 postgres postgres 936026112 Dec 14 07:20 pg_psort.13268.3
> -rw------- 1 postgres postgres 8208384 Dec 14 06:36 pg_psort.13268.4
> -rw------- 1 postgres postgres 15699116 Dec 14 06:36 pg_psort.13268.5
> -rw------- 1 postgres postgres 19002244 Dec 14 06:36 pg_psort.13268.6
> -rw------- 1 postgres postgres 2097152 Dec 9 06:33 pg_psort.25350.0
> -rw------- 1 postgres postgres 2146304 Dec 9 06:33 pg_psort.25350.1
> -rw------- 1 postgres postgres 2277376 Dec 9 06:33 pg_psort.25350.2
> -rw------- 1 postgres postgres 1597440 Dec 9 06:33 pg_psort.25350.3
> -rw------- 1 postgres postgres 1064960 Dec 9 06:33 pg_psort.25350.4
> -rw------- 1 postgres postgres 1327104 Dec 9 06:33 pg_psort.25350.5
> -rw------- 1 postgres postgres 0 Dec 9 06:32 pg_psort.25350.6
>
> I have another database that is almost identical on a different
> machine. There are no pg_psort.xxxx files there. I am wondering:
>
> 1. What are these files?

sort files for stuff like ORDER BY queries...

> 2. Do I need them?

as long as you aren't running a query, you can safely remove them...

> 3. If I don't need them is it safe to remove them?

yes...

Also, what version of PostgreSQL are you running? I swore that more
recent versions of PostgreSQL cleaned up better behind itself...

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org