[ballon_monkey]

If your DB is write heavy, tune it for writes...

[tomnipotent]

You can't tune your way out of this constraint. The heap table and MVCC implementation put a hard ceiling on what can be accomplished without reaching for another tool.