Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Paquier
Subject Re: Bump default wal_level to logical
Date
Msg-id 20200608064555.GE2589@paquier.xyz
Whole thread Raw
In response to Re: Bump default wal_level to logical  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Bump default wal_level to logical  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Tree view 
On Mon, Jun 08, 2020 at 11:59:14AM +0530, Amit Kapila wrote:
> I think we should first do performance testing to see what is the
> overhead of making this default.  I think pgbench read-write at
> various scale factors would be a good starting point.  Also, we should
> see how much additional WAL it generates as compared to current
> default.

+1.  I recall that changing wal_level to logical has been discussed in
the past and performance was the actual take to debate on.
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Bump default wal_level to logical
Next
From: Michael Paquier
Date:
Subject: Re: Removal of currtid()/currtid2() and some table AM cleanup