pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (3+ messages)  latest in thread

Message-ID: <b41c75520809050537q14bbe7f8n4df8066a3e6f7099@mail.gmail.com>
Permalink:  ../b41c75520809050537q14bbe7f8n4df8066a3e6f7099@mail.gmail.com/
Also on:    postgresql.org/message-id/b41c75520809050537q14bbe7f8n4df8066a3e6f7099@mail.gmail.com

 · 

reply

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