RE: pg_sorttemp files

Поиск
Список
Период
Сортировка
От Nicolas Huillard
Тема RE: pg_sorttemp files
Дата
Msg-id 01BFB4F9.3798CB40@agen.int.ghs
обсуждение исходный текст
Ответ на pg_sorttemp files  ("brianb" <brianb-pgadmin@edsamail.com>)
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_sorttemp files
Следующее
От: Ze Luis
Дата:
Сообщение: backup of my database...