Re: [HACKERS] WAL performance with wal_sync_method = open_sync

2001-04-29 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: > I'm playing with wal parameters and found that wal_sync_method = > open_sync enormously enhance the performance on my machine. Without it > (using default fsync) I got only 90 tps at the best using pgbench (-s > 2). However if I set wal_sync_method = open

[HACKERS] WAL performance with wal_sync_method = open_sync

2001-04-28 Thread Tatsuo Ishii
Hi, I'm playing with wal parameters and found that wal_sync_method = open_sync enormously enhance the performance on my machine. Without it (using default fsync) I got only 90 tps at the best using pgbench (-s 2). However if I set wal_sync_method = open_sync, I get ~200 tps. I have checked Postgr