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

From David Rowley
Subject Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion(EDB created version)
Date
Msg-id CAKJS1f8SbYhB=aQ6nsJdEk=uOCqGzyfC-8nnOG9ahLVORa4BFQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version)  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion(EDB created version)
List pgsql-bugs
On Wed, 30 Jan 2019 at 18:08, Toshi Harada <harada.toshi@po.ntt-tx.co.jp> wrote:
> explain_bigsql_11.1.txt explain analyze log.
> explain_edb_10.6.txt    explain analyze log.
> explain_edb_11.0.txt    explain analyze log.
> select_model.sql        explain analyze statement.
> settings_bigsql_11.1    BigSQL 11 configuration.
> settings_diff.txt       EDB 11 and BigSQL 11 diff
> settings_edb_10.6       EDB 10 configuration.
> settings_edb_11.1       EDB 11 configuration.

Most likely down to the collation being C on the EDB versions and
Japanese_Japan.932 on the bigsql one.

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


pgsql-bugs by date:

Previous
From: Toshi Harada
Date:
Subject: Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version)
Next
From: Michael Paquier
Date:
Subject: Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes