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

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: paolo(dot)saul(at)verizonconnect(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes
Date: 2019-01-29 18:36:51
Message-ID: CAMkU=1zCg10FifGnY9LTUyEO_wKVsXdeGoO092+RyaFpg+mAGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Tue, Jan 29, 2019 at 12:46 AM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 15609
> Logged by: Jean Paolo Saul
> Email address: paolo(dot)saul(at)verizonconnect(dot)com
> PostgreSQL version: 11.1
> Operating system: CentOS Linux release 7.6.1810 (Core)
> Description:
>
> Summary:
> We are considering upgrading to PG11 and during performance testing we
> have found that
> PostgreSQL 11 inserts are around 25% slower than inserts in PostgreSQL
> 9.5.
>
> Tools Used:
> pgbench (11.1)
>

Can you show the actual pgbench command line used, and the contents of the
file specified by -f ?

Cheers,

Jeff

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2019-01-29 18:42:03 Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windows version (EDB created version)
Previous Message Francisco Olarte 2019-01-29 11:22:14 Re: BUG #15612: pgadmin4