Tom --
Thanks for the pointers and advice. We've started by doubling
max_locks and halving shared_buffers, we'll see how it goes.
Brian
On Oct 10, 2009, at 7:56 PM, Tom Lane wrote:
Brian Karlak zen...@metaweb.com writes:
out of shared memory HINT: You might need to increase
Hello All --
I have implemented table partitioning in order to increase performance
in my database-backed queuing system. My queue is partitioned by
job_id into separate tables that all inherit from a base queue table.
Things were working swimmingly until my system started managing
Brian Karlak zen...@metaweb.com writes:
out of shared memory HINT: You might need to increase
max_locks_per_transaction
You want to do what it says ...
1) We've already tuned postgres to use ~2BG of shared memory -- which
is SHMAX for our kernel. If I try to increase