Re: Odd files

I figured that they were temp files.  I was intruiged to see it use the
local directory instead of /tmp though.

Upgrading to 7.1 will be quite a task since the server is heavily used
by the company, but a project is in the works.

Thanks for the advice.  I just wanted to re-assure my assumptions before
taking any action.

-Rob


> Those are temporary files used for sorting.  It was a probably a cleanup
> problem on 6.5 (perhaps the query aborted or something leaving the files?
> not sure).  As long as you know that the process is still not using them
> they should be safe to delete.  (And you should probably update to 7.1
> when it comes out :) )
>
> Stephan Szabo
> sszabo@bigpanda.com
>
> On Wed, 20 Dec 2000, Robert Dege wrote:
>
> > I've been running postgresql for quite a while now.  And it's been
> > working with minimal errors, leaving me in a fat, dumb and happy state.
> > Recently though, I ran out of disk space on my 1 partition.  Upon
> > investigation, it appears that one of my databases was to blame.  But
> > here's the odd part:
> >
> > [base/cm]>ls -l
> >
> > -rw-------   1 postgres postgres        0 May 28  2000 pg_sorttemp2662.0
> > -rw-------   1 postgres postgres        0 May 28  2000 pg_sorttemp2662.1
> > -rw-------   1 postgres postgres        0 May 28  2000 pg_sorttemp2662.2
> > -rw-------   1 postgres postgres        0 May 28  2000 pg_sorttemp2662.3
> > -rw-------   1 postgres postgres        0 May 28  2000 pg_sorttemp2662.4
> > -rw-------   1 postgres postgres        0 May 28  2000 pg_sorttemp2662.5
> > -rw-------   1 postgres postgres        0 May 28  2000 pg_sorttemp2662.6
> > -rw-------   1 postgres postgres        0 May 28  2000
> > pg_sorttemp32606.0
> > -rw-------   1 postgres postgres        0 May 28  2000
> > pg_sorttemp32606.1
> > -rw-------   1 postgres postgres        0 May 28  2000
> > pg_sorttemp32606.2
> > -rw-------   1 postgres postgres        0 May 28  2000
> > pg_sorttemp32606.3
> > -rw-------   1 postgres postgres        0 May 28  2000
> > pg_sorttemp32606.4
> > -rw-------   1 postgres postgres        0 May 28  2000
> > pg_sorttemp32606.5
> > -rw-------   1 postgres postgres        0 May 28  2000
> > pg_sorttemp32606.6
> > -rw-------   1 postgres postgres 115482624 Dec 18 23:46
> > pg_sorttemp3946.0
> > -rw-------   1 postgres postgres 109785088 Dec 18 23:46
> > pg_sorttemp3946.1
> > -rw-------   1 postgres postgres 100233216 Dec 18 23:46
> > pg_sorttemp3946.2
> > -rw-------   1 postgres postgres 86548480 Dec 18 23:46 pg_sorttemp3946.3
> > -rw-------   1 postgres postgres 63303680 Dec 18 23:46 pg_sorttemp3946.4
> > -rw-------   1 postgres postgres 43204608 Dec 18 23:46 pg_sorttemp3946.5
> > -rw-------   1 postgres postgres        0 Dec 19 09:37 pg_sorttemp3946.6
> >
> > My questions:
> > What are these files?
> > Are they safe to delete?
> >
> >
> > Thanks for any input
> >
> > -Rob
> >