Re: Bump default wal_level to logical - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Bump default wal_level to logical
Date
Msg-id CAH2-WznVBnRkAa5L-KCEx-p8GUcTHkMh1azFED7s7Rk7v2VUag@mail.gmail.com
Whole thread Raw
In response to Re: Bump default wal_level to logical  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Mon, Jun 8, 2020 at 12:28 PM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> On a quantum-mechanics level, sure, but after Andres's snapshot
> scalability patches, will it be measurable?  (Besides, if your workload
> is so high that you're measurably affected by the additional unused
> PGPROC entries, you can always tune it lower.)

The point that Robert went on to make about the increased WAL volume
from logging old primary key (or replica identity) values was a
stronger argument, IMV.

-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: hashagg slowdown due to spill changes
Next
From: Jeff Davis
Date:
Subject: Re: hashagg slowdown due to spill changes