On Sat, 27 Sep 2008, John Huttley wrote:
I've got 32M shared on a 1G machine and 16 checkpoint segments. I'll run some tests against 64 segments and see what happens.
Increase shared_buffers to 256MB as well. That combination should give you much better performance with the type of update you're doing. Right now the database server has to write the index blocks updated to disk all the time because it has so little working room to store them in. If an index block is updated but there is room to keep it memory, it doesn't have to get written out, which considerably lowers the overhead here.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD
