RE: Temporary tables prevent autovacuum, leading to XID wraparound

Поиск
Список
Период
Сортировка
От Tsunakawa, Takayuki
Тема RE: Temporary tables prevent autovacuum, leading to XID wraparound
Дата
Msg-id 0A3221C70F24FB45833433255569204D1F8B1515@G01JPEXMBYT05
обсуждение исходный текст
Ответ на Re: Temporary tables prevent autovacuum, leading to XID wraparound  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-hackers
From: Michael Paquier [mailto:michael.paquier@gmail.com]
> > postmaster deletes temporary relation files at startup by calling
> > RemovePgTempFiles() regardless of whether it's in recovery.  It
> > doesn't call that function during auto restart after a crash when
> > restart_after_crash is on.
> 
> The comment on top of RemovePgTempFiles() states the following:
>  * NOTE: we could, but don't, call this during a post-backend-crash restart
>  * cycle.  The argument for not doing it is that someone might want to
> examine
>  * the temp files for debugging purposes.  This does however mean that
>  * OpenTemporaryFile had better allow for collision with an existing temp
>  * file name.

Yes, I saw that comment.  postmaster keeps orphaned temp relation files only after a crash when restart_after_crash is
on.


> Nice to hear that.  Please note that I did not check your patch, so I cannot
> conclude on its correctness in details.

I thought so.  Don't mind.

Regards
Takayuki Tsunakawa




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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Temporary tables prevent autovacuum, leading to XID wraparound
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Re: [HACKERS] More stats about skipped vacuums