Re: autovacuum launcher using InitPostgres

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: autovacuum launcher using InitPostgres
Date: 2009-08-31 18:52:28
Message-ID: 20090831185228.GJ6060@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-31 18:53:55 Re: autovacuum launcher using InitPostgres
Previous Message Kevin Grittner 2009-08-31 18:44:10 Re: 8.5 release timetable, again