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
