[ADMIN] Insert Performance with WAL and Fsync

2002-01-14 Thread Mike Schroepfer
Hi All, Our application needs to do a moderate level of inserts into the database as it runs. We can hit 100-200 inserts a second under certain conditions - and it is not something we can batch up for later processing. While testing out postgres I noticed some trobling performance data under

[ADMIN] Insert Performance with WAL and Fsync

2002-01-09 Thread Mike Schroepfer
Hi All, Our application needs to do a moderate level of inserts into the database as it runs. We can hit 100-200 inserts a second under certain conditions - and it is not something we can batch up for later processing. While testing out postgres I noticed some trobling performance data under