Temporary sorting space

From: Richard Boyes <r(dot)boyes(at)auckland(dot)ac(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Temporary sorting space
Date: 2001-03-07 03:11:23
Message-ID: 3AA5A6DB.AA840E27@auckland.ac.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

Inside the $PGDATA/base/thedatabase I came across a rather
large file called pg_sorttemp28193.0 (~ 587 MB). Our datbase
is not anywhere near this large, so I can only guess this was
a query gone awry that needed a large amount of sorting space.
Around the time this file was created the database server
also crashed, I'm wondering if this was a cause of it
(the server crashed due to a memory problem). Could that be possible ?

Also, would I now be safe in removing this file ?

Thanks
Richard.

--
Richard Boyes Tel: 64 09 373 7599 x3055
University of Auckland Fax: 64 09 373 7468

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erik Tennant 2001-03-07 03:48:46 JRelationalFramework
Previous Message GH 2001-03-07 02:38:02 Re: Standard Deviation/Variance function development