From: | Nicolas Huillard <nhuillard(at)ghs(dot)fr> |
---|---|
To: | "'brianb'" <brianb-pgadmin(at)edsamail(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | RE: pg_sorttemp files |
Date: | 2000-05-03 10:15:04 |
Message-ID: | 01BFB4F9.3798CB40@agen.int.ghs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)edsamail(dot)com]
Date: mercredi 3 mai 2000 11:56
À: Nicolas Huillard
Cc: pgsql-admin(at)postgresql(dot)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(at)edsamail(dot)com]
> Date: mercredi 3 mai 2000 04:32
> À: pgsql-admin(at)postgresql(dot)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(at)edsamail(dot)com>
> http://www.baquiran.com/
> AIM: bbaquiran
--
Brian Baquiran <brianb(at)edsamail(dot)com>
http://www.baquiran.com/
AIM: bbaquiran
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-05-03 10:16:51 | Re: pg_sorttemp files |
Previous Message | brianb | 2000-05-03 09:56:16 | Re: pg_sorttemp files |