Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windows version (EDB created version)

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)jp, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windows version (EDB created version)
Date: 2019-01-29 18:42:03
Message-ID: CAMkU=1xL22o6KpSS9ZXm4Oy0V2xB1oeuqO0EAVzjjUR_g+zqQg@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: 15610
> Logged by: Toshi Harada
> Email address: harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Saul, Jean Paolo 2019-01-29 22:05:02 Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes
Previous Message Jeff Janes 2019-01-29 18:36:51 Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes