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

From Dimitri
Subject Re: What is the most optimal config parameters to keep stable write TPS ?..
Date
Msg-id 5482c80a0905120236m3ec8a9c3i53daccbdbde6c668@mail.gmail.com
Whole thread Raw
In response to Re: What is the most optimal config parameters to keep stable write TPS ?..  (Laurent Laborde <kerdezixe@gmail.com>)
List pgsql-performance
It's just one of the test conditions - "what if there 2000 users?" - I
know I may use pgpool or others, but I also need to know the limits of
the database engine itself.. For the moment I'm limiting to 256
concurrent sessions, but config params are kept like for 2000 :-)

Rgds,
-Dimitri

On 5/12/09, Laurent Laborde <kerdezixe@gmail.com> wrote:
> 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: Laurent Laborde
Date:
Subject: Re: What is the most optimal config parameters to keep stable write TPS ?..
Next
From: Scott Marlowe
Date:
Subject: Re: Timestamp index not used in some cases