On Tue, May 12, 2009 at 12:49 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > 1. There is no (portable) way to pass the connection from the postmaster > to another pre-existing process. [Googles.] It's not obvious to me that SCM_RIGHTS is non-portable, and Windows has an API call WSADuplicateSocket() specifically for this purpose. > 2. You'd have to track which database, and probably which user, each > such backend had been launched for; reconnecting a backend to a new > database is probably impractical and would certainly invalidate all > the caching. User doesn't seem like a major problem, but I understand your point about databases, which would presumably preclude the Apache approach of having every backend call accept() on the master socket. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
