Re: [PERFORM] wal_level=archive gives better performance than minimal - why?

2012-01-16 Thread Tomas Vondra
On 16.1.2012 23:35, Greg Smith wrote: > On 01/12/2012 06:17 PM, Tomas Vondra wrote: >> I've run a series fo pgbench benchmarks with the aim to see the effect >> of moving the WAL logs to a separate drive, and one thing that really >> surprised me is that the archive log level seems to give much bet

Re: [PERFORM] wal_level=archive gives better performance than minimal - why?

2012-01-16 Thread Greg Smith
On 01/12/2012 06:17 PM, Tomas Vondra wrote: I've run a series fo pgbench benchmarks with the aim to see the effect of moving the WAL logs to a separate drive, and one thing that really surprised me is that the archive log level seems to give much better performance than minimal log level. How r