Re: What is the most optimal config parameters to keep stable write TPS ?..

From: Laurent Laborde <kerdezixe(at)gmail(dot)com>
To: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: What is the most optimal config parameters to keep stable write TPS ?..
Date: 2009-05-12 09:23:46
Message-ID: 8a1bfe660905120223n5724725cr451003a66167c05c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, May 11, 2009 at 6:31 PM, Dimitri <dimitrik(dot)fr(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

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