pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedYou may need to increase mas_loks_per_trasaction
3+ messages / 3 participants
[nested] [flat]
* You may need to increase mas_loks_per_trasaction
@ 2008-09-05 11:59 Jonas Pacheco <jonas@migrate.com.br>
2008-09-05 12:37 ` Re: You may need to increase mas_loks_per_trasaction Claus Guttesen <kometen@gmail.com>
2008-09-05 20:43 ` Re: You may need to increase mas_loks_per_trasaction Greg Smith <gsmith@gregsmith.com>
0 siblings, 2 replies; 3+ messages in thread
From: Jonas Pacheco @ 2008-09-05 11:59 UTC (permalink / raw)
To: pgsql-performance
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
max_prepared_transactions?
shared_buffers?
wal_buffers?
max_fsm_relations?
max_fsm_pages?
Atenciosamente,
Jonas Rodrigo
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: You may need to increase mas_loks_per_trasaction
2008-09-05 11:59 You may need to increase mas_loks_per_trasaction Jonas Pacheco <jonas@migrate.com.br>
@ 2008-09-05 12:37 ` Claus Guttesen <kometen@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Claus Guttesen @ 2008-09-05 12:37 UTC (permalink / raw)
To: Jonas Pacheco <jonas@migrate.com.br>; +Cc: pgsql-performance
> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: You may need to increase mas_loks_per_trasaction
2008-09-05 11:59 You may need to increase mas_loks_per_trasaction Jonas Pacheco <jonas@migrate.com.br>
@ 2008-09-05 20:43 ` Greg Smith <gsmith@gregsmith.com>
1 sibling, 0 replies; 3+ messages in thread
From: Greg Smith @ 2008-09-05 20:43 UTC (permalink / raw)
To: Jonas Pacheco <jonas@migrate.com.br>; +Cc: pgsql-performance
On Fri, 5 Sep 2008, Jonas Pacheco wrote:
> max_prepared_transactions?
This is covered pretty well by the documentation:
http://www.postgresql.org/docs/current/static/runtime-config-resource.html
There are suggestions for everything else you asked about (and a few more
things you should also set) at
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-09-05 20:43 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-05 11:59 You may need to increase mas_loks_per_trasaction Jonas Pacheco <jonas@migrate.com.br>
2008-09-05 12:37 ` Claus Guttesen <kometen@gmail.com>
2008-09-05 20:43 ` Greg Smith <gsmith@gregsmith.com>
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