From: | will trillich <will(at)serensoft(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Temporary sorting space |
Date: | 2001-03-07 03:59:18 |
Message-ID: | 20010306215918.G31969@mail.serensoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Mar 07, 2001 at 04:11:23PM +1300, Richard Boyes wrote:
> 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 ?
i'm not much of a guru, but here's how i'd test the safety of
removing any file:
rename it or put it into a
subdirectory of wherever it is now.
then restart your pg engine and see if something breaks. test
heavily. after a backup, and a week of no troubles, zap your file.
if something breaks, put it back!
--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'
will(at)serensoft(dot)com
http://newbieDoc.sourceforge.net/ -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-03-07 04:04:55 | Re: vacuum analyze returns "OID IS INVALID. TUPGONE 1" on pg_language |
Previous Message | Erik Tennant | 2001-03-07 03:48:46 | JRelationalFramework |