Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5BC9F632815 for ; Wed, 31 Mar 2010 03:51:05 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 80405-05 for ; Wed, 31 Mar 2010 06:50:53 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f225.google.com (mail-fx0-f225.google.com [209.85.220.225]) by mail.postgresql.org (Postfix) with ESMTP id E945E632644 for ; Wed, 31 Mar 2010 03:50:52 -0300 (ADT) Received: by fxm25 with SMTP id 25so211640fxm.3 for ; Tue, 30 Mar 2010 23:50:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:cc:content-type; bh=KYDGLGaGHEMXJLD1RizgxQFnjhhc4qRt8HMZh4MrcaA=; b=SMwUluqVs2UoqvPulpMmxRp8uVjCH5J/A02jnt001aCHPfnih0zxqT7F9gMPKxpxGV 2yC7xgGnScABs6lzw7DV4Uo5g56spfMql10+BoXqfKz6rYuOdJA6iBM/fK7TQq/ilGZx yr74h/zyTLaNvdzLjKXlTydk6OslllJS3N2Bk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=KUWdmk/zoOhuUfoUK4AfIxt/ytDL3pLVlbxSd9sLsGvRXeJQMy375YfTwHmGMCrQ6v AgmrdL1FYG87xnpIyTUGf60EAoCzV/c76X6gIAFTA72NEdSBHS7pjvO9tds119JDZvPc LahR5kMlOMP6p1tPOCALD8CzpG5Mj2d4ZoCO4= MIME-Version: 1.0 Received: by 10.103.226.6 with HTTP; Tue, 30 Mar 2010 23:50:51 -0700 (PDT) In-Reply-To: References: Date: Wed, 31 Mar 2010 08:50:51 +0200 Received: by 10.103.86.32 with SMTP id o32mr4328627mul.99.1270018251311; Tue, 30 Mar 2010 23:50:51 -0700 (PDT) Message-ID: Subject: Re: Virtualization vs. sharing a server From: Jaume Sabater To: Ramiro Barreca Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/266 X-Sequence-Number: 34065 On Mon, Mar 29, 2010 at 4:50 PM, Ramiro Barreca wrote: > As this is a very heterogeneous platform (from Oracle 10g, SQL Server 2008, > Firebird 2.1, Mysql 5, Postgre 8.4 up to Informix 5 and even COBOL apps) whe > are evaluating Virtualization or just sharing a server among PostgreSQL and > firebird or MySQL. > As Virtualiaztion is almost discarded after reading many articles that > locate this option in the "don'ts-list", we want to know your experience (if > any) about installing a PostgreSQL and a Firebird server in the same Linux > server. Virtualisation is not a bad option per-se. Just don't expect the same performance as if it was running on bare metal. I have a VPS with Xen Hypervisor, 4 GB of RAM at the moment, running PostgreSQL 8.4, MongoDB and MySQL. No problems at all. The setup includes LVM, virtual disks are images on real disk. It's working just fine, but it won't "hold" forever. It's a "cheap" solution at the moment, affordable and performs very well. But I don't expect it to perform as if there were no virtualisation layer. > Is there a configuration option we need to consider to share this server? > What is the recomended hardware for a PostgreSQL server that has to support > between 500 and 1000 simultaneous user connections? Is there a whitepaper > about this? You definitely want to do connection pooling when possible, or try to share tables among several database servers to spread the load. 500 up to 1000 simultaneous connections are very resource consuming, no matter which hardware you have. Of course it also depends on the type of application your users are running... -- Jaume Sabater http://linuxsilo.net/ "Ubi sapientas ibi libertas"