> Anyway, with fsync enabled using standard fsync(), I get roughly 300-400 > inserts per second. With fsync disabled, I get about 7000 inserts per > second. When I re-enable fsync but use the open_sync option, I can get > about 2500 inserts per second.
You are getting 300-400 inserts/sec with fsync on? If you don't mind me asking, what's your hardware? (also, have you checked fsync on #s with the new bgwriter in 7.5?) Merlin ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
