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

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>, "Michael Paesold" <mpaesold(at)gmx(dot)at>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com>, "Peter Eisentraut" <peter_e(at)gmx(dot)net>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Autovacuum launcher doesn't notice death of postmaster immediately
Date: 2007-06-09 05:55:52
Message-ID: D425483C2C5C9F49B5B7A41F89441547010006FA@postal.corporate.connx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org [mailto:pgsql-hackers-
> owner(at)postgresql(dot)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(at)postgresql(dot)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]

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Cui Shijun 2007-06-09 06:11:23 Re: Issues with factorial operator
Previous Message Dann Corbit 2007-06-09 05:50:12 Re: Issues with factorial operator

Browse pgsql-patches by date

  From Date Subject
Next Message Jim C. Nasby 2007-06-09 07:39:19 Re: Controlling Load Distributed Checkpoints
Previous Message Joshua D. Drake 2007-06-09 05:49:00 Re: Autovacuum launcher doesn't notice death of postmaster immediately