From: Claus Guttesen <kometen@gmail.com>
To: Jonas Pacheco <jonas@migrate.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: You may need to increase mas_loks_per_trasaction
Date: Fri, 5 Sep 2008 14:37:53 +0200
Message-ID: <b41c75520809050537q14bbe7f8n4df8066a3e6f7099@mail.gmail.com> (raw)
In-Reply-To: <BC49B993FB36774A9ABD00096D42E6872523E7@mgtsrv02.migrate.local>
References: <alpine.DEB.1.10.0809051247450.4454@aragorn.flymine.org>
<BC49B993FB36774A9ABD00096D42E6872523E7@mgtsrv02.migrate.local>
> Considering a quad core server processor, 4 GBs of RAM memory, disk Sata
> 2.
>
> What is the recommended setting for the parameters:
>
> max_connections:70
Depends on how many clients that access the database.
> shared_buffers?
I have mine at 512 MB but I will lower it and see how it affects
performance. I have 16 GB in my server.
> max_fsm_relations?
> max_fsm_pages?
Perform a vacuum analyze verbose and look at the last few lines. This
will tell you whether you need to increase max_fsm_*.
Consider lowering random_page_cost so it favoes indexex more often
than seq. scans.
But if you don't get a decent raid-controller your data will move slow
and tuning will only make a minor difference.
--
regards
Claus
When lenity and cruelty play for a kingdom,
the gentler gamester is the soonest winner.
Shakespeare
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: kometen@gmail.com, jonas@migrate.com.br
Subject: Re: You may need to increase mas_loks_per_trasaction
In-Reply-To: <b41c75520809050537q14bbe7f8n4df8066a3e6f7099@mail.gmail.com>
References: <alpine.DEB.1.10.0809051247450.4454@aragorn.flymine.org> <BC49B993FB36774A9ABD00096D42E6872523E7@mgtsrv02.migrate.local> <b41c75520809050537q14bbe7f8n4df8066a3e6f7099@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox