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