Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes
Date
Msg-id 20190130052140.GO3121@paquier.xyz
Whole thread Raw
In response to Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-bugs
On Tue, Jan 29, 2019 at 07:30:09AM +0000, Andrew Gierth wrote:
> The default wal_level changed between pg 9.6 and pg10, does reverting
> that change make any difference? (this is just a guess)

It seems to me that Andrew has the good conclusion here.  The OP is
mentioning that a couple of data folders are just initdb'd, which
could point out to the fact that the default configuration set is used
for all of them.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: David Rowley
Date:
Subject: Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion(EDB created version)
Next
From: Toshi Harada
Date:
Subject: Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion(EDB created version)