Re: [GENERAL] wal_level=minimal produces more data than archive level

2011-04-02 Thread Tom Lane
Tomas Vondra writes: > Dne 3.4.2011 02:45, Tom Lane napsal(a): >> I wonder whether the discrepancy relates to having to produce >> full-page-image WAL entries during the first touch of a page during the >> pgbench run, versus having already done so in initialization. If you >> force a checkpoint

Re: [GENERAL] wal_level=minimal produces more data than archive level

2011-04-02 Thread Tomas Vondra
Dne 3.4.2011 02:45, Tom Lane napsal(a): > Tomas Vondra writes: >> I've been playing with various wal_level settings, mainly to find out >> what is the overhead of hot standby, and I've noticed a strange thing. >> In some cases the wal_level=minimal produces signigicantly more xlog >> data than wal

Re: [GENERAL] wal_level=minimal produces more data than archive level

2011-04-02 Thread Tom Lane
Tomas Vondra writes: > I've been playing with various wal_level settings, mainly to find out > what is the overhead of hot standby, and I've noticed a strange thing. > In some cases the wal_level=minimal produces signigicantly more xlog > data than wal_level=archive (and hot_standby). > ... > Whic

[GENERAL] wal_level=minimal produces more data than archive level

2011-04-02 Thread Tomas Vondra
Hi everyone, I've been playing with various wal_level settings, mainly to find out what is the overhead of hot standby, and I've noticed a strange thing. In some cases the wal_level=minimal produces signigicantly more xlog data than wal_level=archive (and hot_standby). ===