Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id A618863343E for ; Tue, 13 Jul 2010 11:42:36 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 04211-01-2 for ; Tue, 13 Jul 2010 14:42:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.hi-media-techno.com (smtp1.hi-media-techno.com [195.158.241.85]) by mail.postgresql.org (Postfix) with ESMTP id 4E8CB63320A for ; Tue, 13 Jul 2010 11:42:28 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 7680693BCF; Tue, 13 Jul 2010 16:42:25 +0200 (CEST) Received: from smtp1.hi-media-techno.com ([127.0.0.1]) by localhost (smtp1.backbone.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uFtasR1EKE46; Tue, 13 Jul 2010 16:42:24 +0200 (CEST) Received: from mail1.hi-media-techno.com (unknown [192.168.27.17]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id BE2DB93B9E; Tue, 13 Jul 2010 16:42:24 +0200 (CEST) Received: from dim (unknown [83.167.62.196]) by mail1.hi-media-techno.com (Postfix) with ESMTPSA id 7EFAC7B0CD; Tue, 13 Jul 2010 16:42:24 +0200 (CEST) Received: by dim (Postfix, from userid 1000) id 57A3E672EF; Tue, 13 Jul 2010 16:42:23 +0200 (CEST) From: Dimitri Fontaine To: Tom Lane Cc: Josh Berkus , Robert Haas , Craig Ringer , Kevin Grittner , Greg Smith , Matthew Wakeling , Brad Nicholson , pgsql-performance@postgresql.org Subject: Re: Pooling in Core WAS: Need help in performance tuning. Organization: Hi-Media References: <4C369346.6010501@postnewspapers.com.au> <8760.1278650566@sss.pgh.pa.us> <1278680186.1914.36.camel@bnicholson-desktop> <4C36F57102000025000332F6@gw.wicourts.gov> <4C36FEAD02000025000332FC@gw.wicourts.gov> <4C37A9C1.1060405@2ndquadrant.com> <4C37791C0200002500033379@gw.wicourts.gov> <4C37CBFB.1000800@agliodbs.com> <4C37EA1D.6000008@postnewspapers.com.au> <4C38BF03.6060503@agliodbs.com> <19244.1278787866@sss.pgh.pa.us> User-Mail-Address: dfontaine@hi-media.com Date: Tue, 13 Jul 2010 16:42:23 +0200 In-Reply-To: <19244.1278787866@sss.pgh.pa.us> (Tom Lane's message of "Sat, 10 Jul 2010 14:51:06 -0400") Message-ID: <87d3ur78a8.fsf@hi-media-techno.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201007/207 X-Sequence-Number: 39596 Tom Lane writes: > I agree with the comments to the effect that this is really a packaging > and documentation problem. There is no need for us to re-invent the > existing solutions, but there is a need for making sure that they are > readily available and people know when to use them. On this topic, I think we're getting back to the idea of having non-core daemon helpers that should get "supervised" the way postmaster already does with backends wrt starting and stoping them at the right time. So a supervisor daemon with a supervisor API that would have to support autovacuum as a use case, then things like pgagent, PGQ and pgbouncer, would be very welcome. What about starting a new thread about that? Or you already know you won't want to push the extensibility of PostgreSQL there? Regards, -- dim