Re: WIP: getting rid of the pg_database flat file - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: WIP: getting rid of the pg_database flat file
Date
Msg-id 20090812180217.GK5721@alvh.no-ip.org
Whole thread Raw
In response to Re: WIP: getting rid of the pg_database flat file  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: WIP: getting rid of the pg_database flat file  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: WIP: getting rid of the pg_database flat file  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:

> > (BTW I assume there is going to be an index on OID
> > available on pg_database after the shared relcache initialization?)
> 
> Yeah.  That's not in the patch I sent last night, but the OID index has
> to become nailed too in order to allow removing FindMyDatabaseByOid.
> However, I'm not sure that the AV launcher could touch it --- were
> you thinking that would be important?

No, that's for the workers.  The launcher needs all the entries anyway.
(I'm assuming it will be able to check visibility of tuples, correct?
Hmm, it will need to run transactions in order to do that ...)

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


pgsql-hackers by date:

Previous
From: Markus Wanner
Date:
Subject: Re: "Hot standby"?
Next
From: Peter Eisentraut
Date:
Subject: Re: Alpha 1 release notes