Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id F070A1337BB7 for ; Wed, 8 Dec 2010 13:12:29 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 15885-01 for ; Wed, 8 Dec 2010 17:12:22 +0000 (UTC) X-Greylist: delayed 00:18:59.477656 by SQLgrey-1.7.6 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by mail.postgresql.org (Postfix) with ESMTP id 463C31337B93 for ; Wed, 8 Dec 2010 13:12:22 -0400 (AST) Received: from sam.nabble.com ([192.168.236.26]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1PQNGb-0003Qu-8x for pgsql-performance@postgresql.org; Wed, 08 Dec 2010 08:53:21 -0800 Date: Wed, 8 Dec 2010 08:53:21 -0800 (PST) From: salima To: pgsql-performance@postgresql.org Message-ID: <1291827201272-3297619.post@n5.nabble.com> Subject: Tunning Postgres MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.933 tagged_above=-10 required=5 tests=BAYES_50=0.8, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: * X-Archive-Number: 201012/154 X-Sequence-Number: 41606 Pessoal,=20 Estou com uma d=C3=BAvida ao fazer Tunning no arquivo de configura=C3=A7=C3= =A3o do Postgres.=20 Minha aplica=C3=A7=C3=A3o tem varios acessos simult=C3=A2neos, chegando pic= os de 2000 mil ou at=C3=A9 mais. Por ser uma aplica=C3=A7=C3=A3o Web fica dificil de se es= tipular o "max_connections", sem contar que o restante dos par=C3=A2metros faz depend= encia com este. Tenho um servidor dedicado ao Postgre e gostaria de saber qual a melhor ou uma sugest=C3=A3o de configura=C3=A7=C3=A3o, para esta m=C3=A1quina e aplic= a=C3=A7=C3=A3o. Servidor DELL Intel 2 processadores 3.6 GHz Xeon 4 GBs RAM 2 HDs de 320 GB (RAID1) Sistema Operacional Linux - CentOS=20 []'s --=20 View this message in context: http://postgresql.1045698.n5.nabble.com/Tunni= ng-Postgres-tp3297619p3297619.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.