Horton

Re: Autovacuum launcher doesn't notice death of postmaster immediately

Dann Corbit <dcorbit@connx.com>

View thread View on postgr.es
From: "Dann Corbit" <DCorbit@connx.com>
To: "Joshua D. Drake" <jd@commandprompt.com>, "Alvaro Herrera" <alvherre@commandprompt.com>
Cc: "Matthew T. O'Connor" <matthew@zeut.net>, "Jim C. Nasby" <decibel@decibel.org>, "Michael Paesold" <mpaesold@gmx.at>, "Tom Lane" <tgl@sss.pgh.pa.us>, "Andrew Hammond" <andrew.george.hammond@gmail.com>, "Peter Eisentraut" <peter_e@gmx.net>, <pgsql-hackers@postgresql.org>
Date: 2007-06-09T05:55:52Z
Lists: pgsql-hackers 
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-
> owner@postgresql.org] On Behalf Of Joshua D. Drake
> Sent: Friday, June 08, 2007 10:49 PM
> To: Alvaro Herrera
> Cc: Matthew T. O'Connor; Jim C. Nasby; Michael Paesold; Tom Lane; Andrew
> Hammond; Peter Eisentraut; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Autovacuum launcher doesn't notice death of
> postmaster immediately
> 
> Alvaro Herrera wrote:
> > Matthew T. O'Connor escribió:
> >
> >> Ok, but I think the question posed is that in say a virtual hosting
> >> environment there might be say 1,000 databases in the cluster.
> 
> That is uhmmm insane... 1000 databases?

Not in a test environment.  We have several hundred databases here.  Of course, only a few dozen (or at most ~100) are of any one type, but I can imagine that under certain circumstances 1000 databases would not be unreasonable.

[snip]