Thread: pg_sorttemp files
I found a couple of pg_sorttemp* files in my database directory. Is it safe to delete these? They're quite large (around 40MB each) and have a creation date of a couple of days ago. Brian -- Brian Baquiran <brianb@edsamail.com> http://www.baquiran.com/ AIM: bbaquiran
As soon as every postgres back-end server if closed, it is safe to delete these files. I do a... ps axf | grep -e "[P]ID" -e "[p]ost" ... to check for living back-ends... Nicolas Huillard -----Message d'origine----- De: brianb [SMTP:brianb-pgadmin@edsamail.com] Date: mercredi 3 mai 2000 04:32 À: pgsql-admin@postgresql.org Objet: [ADMIN] pg_sorttemp files I found a couple of pg_sorttemp* files in my database directory. Is it safe to delete these? They're quite large (around 40MB each) and have a creation date of a couple of days ago. Brian -- Brian Baquiran <brianb@edsamail.com> http://www.baquiran.com/ AIM: bbaquiran
Ok, thanks. But why are they there in the first place, then? Nicolas Huillard writes: > As soon as every postgres back-end server if closed, it is safe to delete these files. > I do a... > ps axf | grep -e "[P]ID" -e "[p]ost" > ... to check for living back-ends... > > Nicolas Huillard > > -----Message d'origine----- > De: brianb [SMTP:brianb-pgadmin@edsamail.com] > Date: mercredi 3 mai 2000 04:32 > �: pgsql-admin@postgresql.org > Objet: [ADMIN] pg_sorttemp files > > > I found a couple of pg_sorttemp* files in my database directory. Is it safe > to delete these? They're quite large (around 40MB each) and have a creation > date of a couple of days ago. > > Brian > -- > Brian Baquiran <brianb@edsamail.com> > http://www.baquiran.com/ > AIM: bbaquiran -- Brian Baquiran <brianb@edsamail.com> http://www.baquiran.com/ AIM: bbaquiran
On Wed, 3 May 2000, brianb wrote: > Ok, thanks. But why are they there in the first place, then? A backend crash during sorting -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
These files are temporary files used by back-ends while sorting (as their names tell). They where probably forgotten whenthe back-end finished (either a died back-end or some sort or abnormal thing). The fact that these files are big canmean that the corresponding back-ends had problems with the involved queries, thus died without erasing the files. Nicolas Huillard -----Message d'origine----- De: brianb [SMTP:brianb-pgadmin@edsamail.com] Date: mercredi 3 mai 2000 11:56 À: Nicolas Huillard Cc: pgsql-admin@postgresql.org Objet: Re: [ADMIN] pg_sorttemp files Ok, thanks. But why are they there in the first place, then? Nicolas Huillard writes: > As soon as every postgres back-end server if closed, it is safe to delete these files. > I do a... > ps axf | grep -e "[P]ID" -e "[p]ost" > ... to check for living back-ends... > > Nicolas Huillard > > -----Message d'origine----- > De: brianb [SMTP:brianb-pgadmin@edsamail.com] > Date: mercredi 3 mai 2000 04:32 > À: pgsql-admin@postgresql.org > Objet: [ADMIN] pg_sorttemp files > > > I found a couple of pg_sorttemp* files in my database directory. Is it safe > to delete these? They're quite large (around 40MB each) and have a creation > date of a couple of days ago. > > Brian > -- > Brian Baquiran <brianb@edsamail.com> > http://www.baquiran.com/ > AIM: bbaquiran -- Brian Baquiran <brianb@edsamail.com> http://www.baquiran.com/ AIM: bbaquiran