Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes
Date
Msg-id CAMkU=1zCg10FifGnY9LTUyEO_wKVsXdeGoO092+RyaFpg+mAGQ@mail.gmail.com
Whole thread Raw
In response to BUG #15609: synchronous_commit=off insert performance regression with secondary indexes  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes
List pgsql-bugs
Tree view
On Tue, Jan 29, 2019 at 12:46 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      15609
Logged by:          Jean Paolo Saul
Email address:      paolo.saul@verizonconnect.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

pgsql-bugs by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: BUG #15612: pgadmin4
Next
From: Jeff Janes
Date:
Subject: Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version)