pg_sorttemp files
pg_sorttemp files
От:
"brianb" <brianb-pgadmin@edsamail.com>
Дата:
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 http://www.baquiran.com/ AIM: bbaquiran
RE: pg_sorttemp files
От:
Nicolas Huillard <nhuillard@ghs.fr>
Дата:
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 http://www.baquiran.com/ AIM: bbaquiran
Re: pg_sorttemp files
От:
"brianb" <brianb-pgadmin@edsamail.com>
Дата:
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 > http://www.baquiran.com/ > AIM: bbaquiran -- Brian Baquiran http://www.baquiran.com/ AIM: bbaquiran
Re: pg_sorttemp files
От:
Peter Eisentraut <e99re41@DoCS.UU.SE>
Дата:
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
RE: pg_sorttemp files
От:
Nicolas Huillard <nhuillard@ghs.fr>
Дата:
These files are temporary files used by back-ends while sorting (as their names tell). They where probably forgotten when the back-end finished (either a died back-end or some sort or abnormal thing). The fact that these files are big can mean 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 > http://www.baquiran.com/ > AIM: bbaquiran -- Brian Baquiran http://www.baquiran.com/ AIM: bbaquiran