Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the most optimal config parameters to keep stable write TPS ?.. - Mailing list pgsql-performance

From Laurent Laborde
Subject Re: What is the most optimal config parameters to keep stable write TPS ?..
Date
Msg-id 8a1bfe660905120223n5724725cr451003a66167c05c@mail.gmail.com
Whole thread Raw
In response to Re: What is the most optimal config parameters to keep stable write TPS ?..  (Dimitri <dimitrik.fr@gmail.com>)
Responses Re: What is the most optimal config parameters to keep stable write TPS ?..
List pgsql-performance
Tree view 
On Mon, May 11, 2009 at 6:31 PM, Dimitri <dimitrik.fr@gmail.com> wrote:
> Hi Kevin,
>
> PostgreSQL: 8.3.7 & 8.4
> Server: Sun M5000 32cores
> OS: Solaris 10
>
> current postgresql.conf:
>
> #================================
> max_connections = 2000                  # (change requires restart)

Are you sure about the 2000 connections ?
Why don't you use a pgbouncer or pgpool instead ?


--
F4FQM
Kerunix Flan
Laurent Laborde

pgsql-performance by date:

Previous
From: Евгений Василев
Date:
Subject: Timestamp index not used in some cases
Next
From: Dimitri
Date:
Subject: Re: What is the most optimal config parameters to keep stable write TPS ?..