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

Good point! I missed it.. - will 20MB be enough?

Rgds,
-Dimitri

On 5/12/09, Julian v. Bock <bock(at)openit(dot)de> wrote:
> Hi
>
>>>>>> "D" == Dimitri <dimitrik(dot)fr(at)gmail(dot)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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>