Re: autovacuum launcher using InitPostgres

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: autovacuum launcher using InitPostgres
Дата
Msg-id
20090831185228.GJ6060@alvh.no-ip.org
Ответ на
Список
Дерево обсуждения
autovacuum launcher using InitPostgres Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum launcher using InitPostgres Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum launcher using InitPostgres Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum launcher using InitPostgres Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum launcher using InitPostgres Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum launcher using InitPostgres Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum launcher using InitPostgres Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum launcher using InitPostgres Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum launcher using InitPostgres Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum launcher using InitPostgres Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum launcher using InitPostgres Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum launcher using InitPostgres Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum launcher using InitPostgres Magnus Hagander <magnus@hagander.net>
Re: autovacuum launcher using InitPostgres Dimitri Fontaine <dfontaine@hi-media.com>
Re: autovacuum launcher using InitPostgres Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: autovacuum launcher using InitPostgres Alvaro Herrera <alvherre@commandprompt.com>
Re: autovacuum launcher using InitPostgres Tom Lane <tgl@sss.pgh.pa.us>
Re: autovacuum launcher using InitPostgres Tom Lane <tgl@sss.pgh.pa.us>
Tom Lane wrote:

> Actually, there is a better way to do this: if we move up the
> RelationCacheInitializePhase2 call, then we can have the AV launcher
> case just fall out *before* the transaction start.  It can do
> GetTransactionSnapshot inside its own transaction that reads
> pg_database.  This is a better solution because it'll have a more
> up-to-date version of RecentGlobalXmin while scanning pg_database.
> (Indeed, I think this might be *necessary* over the very long haul.)

Hmm, good idea.

> I think I've got the signal handling cleaned up, but need to test.
> Is there any really good reason why autovacuum has its own avl_quickdie
> instead of using quickdie() for SIGQUIT?

No, probably I just copied it because the others were static.  Not sure
about quickdie() itself.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

В списке pgsql-hackers по дате отправления
От: Kevin Grittner
Дата:
От: Alvaro Herrera
Дата:
FAQ