X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id BA78C53DBE for ; Thu, 12 May 2005 16:13:21 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94130-06 for ; Thu, 12 May 2005 19:13:13 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 8E1F853456 for ; Thu, 12 May 2005 16:13:12 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 12 May 2005 14:13:12 -0500 Subject: Re: resource allocation ; postgresql-8.0 From: Scott Marlowe To: "Kavan, Dan (IMS)" Cc: postgres In-Reply-To: <782D2A81EC812642B857B03B506E0B4432648E@granite.omni.imsweb.com> References: <782D2A81EC812642B857B03B506E0B4432648E@granite.omni.imsweb.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1115925192.22291.12.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 12 May 2005 14:13:12 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/168 X-Sequence-Number: 17597 On Thu, 2005-05-12 at 12:56, Kavan, Dan (IMS) wrote: > Scott, > If you had two applications that were each connecting to two different > databases, have you found that it's beneficial to have to different > instances of postgres running? I haven't, but I could see where, if the workloads were very different, it might be advantageous. > I have a few reasons why I think it would be better. One, it would be > beneficial to customize parameters for each application. They would be > different sizes for example and they may each have different amounts of > people connecting to them. Possible. It really depends on how different they are. There are benefits to having only one postmaster running, but since you've got 3gigs+ memory, the memory savings probably isn't one of them. > Two, from a networking perspective, it may > be faster ( 2 different ports rather than one ) I doubt that would be a big difference. > Do you agree with those > reasons or can you think of other reasons it would be wise? Well, running two separate clusters under separate postgres superuser account would afford the maximum in isolation. Plus you could easily place each cluster on it's own storage to provide better performance and keep them from interacting with each other. If, at some later date you decide to put them on separate machines you're aleady halfway there. > It seems > like it would be more administrative work to have 2 different instances, > so there may be some cons to that idea as well. Exactly. You need to schedule separate vacuums for each, etc... I tend to leave it on one cluster unless performance starts to become an issue.