Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, paolo(dot)saul(at)verizonconnect(dot)com
Subject: Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes
Date: 2019-01-30 05:21:40
Message-ID: 20190130052140.GO3121@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Toshi Harada 2019-01-30 05:41:56 Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion(EDB created version)
Previous Message David Rowley 2019-01-30 05:16:14 Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version)