RE: pg_sorttemp*

We are running 6.5 RPM version off of RH 6.1 I believe.

As for the crash's, the data that was being inserted was found to be at
fault. We changed the data and we seem to be doing just fine now, but I'm
sure it will pop up again. I've got the old data around here that I'm going
to analyze when I get a spare minute or two. All the data was being
inserted fine, but when we pulled it out via a PHP script (SELECT) it was
dropping core files on us and wouldn't pull anything out.

Thanks for the help.

-----Original Message-----
From: pgsql-general-owner(at)hub(dot)org [mailto:pgsql-general-owner(at)hub(dot)org]On
Behalf Of Tom Lane
Sent: Monday, June 19, 2000 10:58 AM
To: chris(at)townnews(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] pg_sorttemp*

"Chris Dorr" <chris(at)townnews(dot)com> writes:
> I've got a postgres DB that keeps crashing on me. When I go into my
> base/DBDIR/ and do an ls -la I see a ton of files called pg_sorttemp .
> Some are quite large in size and others have nothing inside of them.
> Would this have anything to do with why our DB is crashing?? Can I
> get rid of them?

They're just temporary files. You can get rid of them if the backends
that created 'em are no longer running. The more interesting question
is why the crashes. What version are you running, and what sort of
query is provoking the crash?

regards, tom lane