Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()
Дата
Msg-id CA+TgmoYCTDq=fsoz3Gb9=D=35Qjz62XAjtavTLqqC-VjUKK2NQ@mail.gmail.com
обсуждение исходный текст
Ответ на END_OF_RECOVERY shutdowns and ResetUnloggedRelations()  (Andres Freund <andres@2ndquadrant.com>)
Ответы Re: END_OF_RECOVERY shutdowns and ResetUnloggedRelations()  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
On Fri, Sep 12, 2014 at 7:22 AM, Andres Freund <andres@2ndquadrant.com> wrote:
> What I like even less is that pg_control is actually marked as
> DB_SHUTDOWNED due to END_OF_RECOVERY. That's just plain wrong. Obviously
> the database was *NOT* shutdown peacefully. I don't see active bugs due
> it besides this, but I think it's likely to either have or create futher
> ones.

I agree.  The database clearly isn't shut down at end of recovery;
it's still active and we're still doing things to it.  If we crash at
that point, we need to go back into recovery on restart.  This seems
open and shut, but maybe I'm missing something.  Why shouldn't we fix
*that*?

With regard to your second email, I agree that
ResetUnloggedRelation(UNLOGGED_RELATION_INIT) needs to issue fsyncs.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Andrew Gierth
Дата:
Сообщение: Re: Final Patch for GROUPING SETS
Следующее
От: Gregory Smith
Дата:
Сообщение: Re: Support for N synchronous standby servers