Thread: pg_sorttemp*
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? ~chris~
"Chris Dorr" <chris@townnews.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
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@hub.org [mailto:pgsql-general-owner@hub.org]On Behalf Of Tom Lane Sent: Monday, June 19, 2000 10:58 AM To: chris@townnews.com Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_sorttemp* "Chris Dorr" <chris@townnews.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
"Chris Dorr" <chris@townnews.com> writes: > We are running 6.5 RPM version off of RH 6.1 I believe. 7.0.2 fixes a heck of a lot of bugs; you would be well advised to update. > 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. Hmm. What data types are involved, and how did you change the data exactly to avoid the bug(s)? regards, tom lane