Christoph Anton Mitterer
christoph.anton.mitte...@physik.uni-muenchen.de
wrote:
Well I'm still very unsure on how to configure many values...
We've increased e.g. shared_buffers, temp_buffers, work_mem,
maintenance_work_mem, max_stack_depth... and this greatly improved
performance. But I
Hi.
I've read through the documentation and while I've seen dozens of
options which allow to set which kind of buffer/cache/shared-mem gets
how big... I do not quite understand how to reach the following.
What we have here at the institute is a quite powerful server, whit
about 100GB RAM that
2011/7/14 Christoph Anton Mitterer
christoph.anton.mitte...@physik.uni-muenchen.de:
Hi.
I've read through the documentation and while I've seen dozens of
options which allow to set which kind of buffer/cache/shared-mem gets
how big... I do not quite understand how to reach the following.
Christoph Anton Mitterer
christoph.anton.mitte...@physik.uni-muenchen.de
wrote:
What we have here at the institute is a quite powerful server,
whit about 100GB RAM that has a PostgreSQL running on it (with
several DBs).
In one cluster (postmaster instance) or separate?
Currently it's