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

On Wed, 30 Jan 2019 at 07:42, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
> 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;

It might also be useful to see the EXPLAIN ANALYZE from each instance.
Different ANALYZE runs can generate different table stats, so the plan
may differ between instances, even if the code and settings are the
same.

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services