X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 4655A9FA5BE for ; Thu, 15 Jun 2006 14:36:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 22035-10 for ; Thu, 15 Jun 2006 14:36:03 -0300 (ADT) X-Greylist: delayed 00:18:21.449211 by SQLgrey- Received: from crestone.coronasolutions.com (crestone.coronasolutions.com [66.45.104.24]) by postgresql.org (Postfix) with ESMTP id 288219FA13E for ; Thu, 15 Jun 2006 14:36:01 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by crestone.coronasolutions.com (Postfix) with ESMTP id 79A866440F3; Thu, 15 Jun 2006 11:17:37 -0600 (MDT) Received: from crestone.coronasolutions.com ([127.0.0.1]) by localhost (crestone.coronasolutions.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17381-08; Thu, 15 Jun 2006 11:17:35 -0600 (MDT) Received: from [192.168.1.100] (c-67-165-220-189.hsd1.co.comcast.net [67.165.220.189]) by crestone.coronasolutions.com (Postfix) with ESMTP id B229F6440E4 for ; Thu, 15 Jun 2006 11:17:35 -0600 (MDT) Message-ID: <44919625.8040200@drivefaster.net> Date: Thu, 15 Jun 2006 11:17:25 -0600 From: Dan Harris User-Agent: Thunderbird 1.5.0.4 (Macintosh/20060516) MIME-Version: 1.0 To: PostgreSQL Performance Subject: Re: Is it possible to start two instances of postgresql? References: <44911706.60204@superlativ.dk> In-Reply-To: <44911706.60204@superlativ.dk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at drivefaster.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/316 X-Sequence-Number: 19673 > kah_hang_ang@toray.com.my wrote: > > >> both of the two database are live but use for two different web app. >> my company don't want to spend more to buy a new server, so then I think of >> to implement both under the same server and one instance.. Just as an anecdote, I am running 30 databases on a single instance and it's working quite well. There may be reasons to run multiple instances but it seems like tuning them to cooperate for memory would pose some problems - e.g. effective_cache_size. -Dan