Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version) - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version)
Date
Msg-id CAMkU=1xL22o6KpSS9ZXm4Oy0V2xB1oeuqO0EAVzjjUR_g+zqQg@mail.gmail.com
Whole thread Raw
In response to BUG #15610: Performance problem of PostgreSQL 11.1 Windows version (EDB created version)  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version)  (David Rowley <david.rowley@2ndquadrant.com>)
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:      15610
Logged by:          Toshi Harada
Email address:      harada.toshi@po.ntt-tx.co.jp
PostgreSQL version: 11.1
Operating system:   Windows Server 2012 R2 Standard Edition (32 CPU)
Description:       

[Overview]

Installing PostgreSQL 11.1 Windows verson (EDB created version) and running
pgbench, tps is very low compared to PostgreSQL 10.6.
Also, tps is lower than PostgreSQL 11.1 Windows version (BIgSQL created
version).
Is there something wrong with the build option of PostgreSQL 11.1 in the EDB
created version?

Can you compare the configuration settings and report any differences?

select name,setting from pg_settings;

Cheers,

Jeff 

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes
Next
From: "Saul, Jean Paolo"
Date:
Subject: Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes