Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D86A41337B8D for ; Wed, 2 Feb 2011 22:55:24 -0400 (AST) 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 30737-09 for ; Thu, 3 Feb 2011 02:55:17 +0000 (UTC) X-Greylist: delayed 00:06:31.077624 by SQLgrey-1.7.6 Received: from mx3.uci.cu (mx3.uci.cu [200.55.140.180]) by mail.postgresql.org (Postfix) with SMTP id 38A301337B92 for ; Wed, 2 Feb 2011 22:55:14 -0400 (AST) Received: (qmail 10854 invoked by uid 507); 3 Feb 2011 02:48:33 -0000 Received: from 10.0.0.185 by ns3.uci.cu (envelope-from , uid 501) with qmail-scanner-2.01st (avp: 5.0.2.0. spamassassin: 3.0.6. perlscan: 2.01st. Clear:RC:1(10.0.0.185):. Processed in 0.800317 secs); 03 Feb 2011 02:48:33 -0000 Received: from unknown (HELO ucimail4.uci.cu) (10.0.0.185) by 0 with SMTP; 3 Feb 2011 02:48:32 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by ucimail4.uci.cu (Postfix) with ESMTP id 1DC9C13253B2; Wed, 2 Feb 2011 21:48:33 -0500 (CST) X-Virus-Scanned: amavisd-new at uci.cu Received: from ucimail4.uci.cu ([127.0.0.1]) by localhost (ucimail4.uci.cu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id C6PgvkUBNONW; Wed, 2 Feb 2011 21:48:32 -0500 (CST) Received: from [10.8.46.57] (unknown [10.8.46.57]) by ucimail4.uci.cu (Postfix) with ESMTP id 157D013253BD; Wed, 2 Feb 2011 21:48:32 -0500 (CST) Subject: Re: Server Configuration From: Marcos Ortiz To: Cesar Arrieta Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Organization: UCI Date: Wed, 02 Feb 2011 21:49:12 -0430 Message-ID: <1296699552.7323.20.camel@marcosluis-Aspire-5251> Mime-Version: 1.0 X-Mailer: Evolution 2.30.3 Content-Transfer-Encoding: 8bit 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: 201102/58 X-Sequence-Number: 42196 On Wed, 2011-02-02 at 15:15 -0300, Cesar Arrieta wrote: > Hi, I have a Server with Fedora Core 11, Tomcat and Postgresql 8.3. > With Hardware: > * 8GB RAM > * 8 processors Intel Xeon E5520 @2.27GHz > * 250GB SATA DISK > > Actually, it serves at most 250 connections. > The problem happends when it serves many many connections at a time, > tables and queries began to get blocked, then I have to kill some > processes > in order to allow other people continue working. > > Wich recommendations could you give me for to configure > postgresql.conf, and could it be eficcient to buy another server with > almost same hardware > in order to use pgPool2 with replication, load balance and parallel > query?. My first recommedation is to update your PostgreSQL version to 9.0 and later you can use the PgPool-II version 3.0 in order to use the Hot standby/Streaming Replication features with it. Here is a example of the configuration of PgPool-II 3.0.1 and PostgreSQL-9.0.2 http://lists.pgfoundry.org/pipermail/pgpool-general/2011-February/003338.html Regards -- Ing. Marcos Luís Ortíz Valmaseda System Engineer -- Database Administrator Centro de Tecnologías de Gestión de Datos (DATEC) Universidad de las Ciencias Informáticas http://postgresql.uci.cu