Postgres Pro
Downloads
Home   >   mailing lists

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

From bock@openit.de (Julian v. Bock)
Subject Re: What is the most optimal config parameters to keep stable write TPS ?..
Date
Msg-id lpab5isbro.fsf@warpcore.i.openit.de
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 
Hi

>>>>> "D" == Dimitri  <dimitrik.fr@gmail.com> writes:

D> current postgresql.conf:

D> #================================
D> max_connections = 2000 # (change requires restart)
D> temp_buffers = 200MB

temp_buffers are kept per connection and not freed until the session
ends. If you use some kind of connection pooling this can eat up a lot
of ram that could be used for caching instead.

Regards,
Julian

pgsql-performance by date:

Previous
From: Dimitri
Date:
Subject: Re: Any better plan for this query?..
Next
From: Stefan Kaltenbrunner
Date:
Subject: Re: Any better plan for this query?..