Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> writes: > Going from wal_level='minimal' to 'archiveÍ' incurs the penalty on > WAL-logging COPY etc. That's a big penalty. However, the difference > between wal_level='archive' and wal_level='hot_standby' should be tiny.
I'm not sure I believe that either, because of the costs associated with logging lock acquisitions. We really need some actual benchmarks in this area, rather than handwaving ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers