Good point! I missed it.. - will 20MB be enough?
Rgds,
-Dimitri
On 5/12/09, Julian v. Bock <bock@openit.de> wrote:
> 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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>