History of WAL_LEVEL (archive vs hot_standby)

From: shamccoy <sputnikv8(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: History of WAL_LEVEL (archive vs hot_standby)
Date: 2014-03-27 21:24:13
Message-ID: 1395955453678-5797717.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello. I've been doing some benchmarks on performance / size differences
between actions when wal_level is set to either archive or hot_standby. I'm
not seeing a ton of difference. I've read some posts about discussions as
to whether this parameter should be simplified and remove or merge these 2
values.

I'd like to understand the historic reason between have the extra
"hot_standby" value. Was it to introduce replication and not disturb the
already working "archive" value? If I'm new to Postgres, is there any
strategic reason to use "archive" at this point if replication is something
I'll be using in the future? I'm not seeing any downside to "hot_standby"
unless I'm missing something fundamental.

Thanks,
Shawn

--
View this message in context: http://postgresql.1045698.n5.nabble.com/History-of-WAL-LEVEL-archive-vs-hot-standby-tp5797717.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David Johnston 2014-03-27 22:06:02 Re: History of WAL_LEVEL (archive vs hot_standby)
Previous Message Andres Freund 2014-03-27 21:15:35 Re: Useless "Replica Identity: NOTHING" noise from psql \d