| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Toshi Harada <harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)jp> |
| Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version) |
| Date: | 2019-01-30 05:16:14 |
| Message-ID: | CAKJS1f8SbYhB=aQ6nsJdEk=uOCqGzyfC-8nnOG9ahLVORa4BFQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Wed, 30 Jan 2019 at 18:08, Toshi Harada <harada(dot)toshi(at)po(dot)ntt-tx(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2019-01-30 05:21:40 | Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes |
| Previous Message | Toshi Harada | 2019-01-30 05:06:29 | Re: BUG #15610: Performance problem of PostgreSQL 11.1 Windowsversion (EDB created version) |