| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | "Saul, Jean Paolo" <paolo(dot)saul(at)verizonconnect(dot)com> |
| Cc: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes |
| Date: | 2019-02-12 01:42:39 |
| Message-ID: | CAH2-WznvXb2KdDVyrmkOvvTEhonCKs4eSF01WeLLgAnSSkPVSw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Mon, Feb 11, 2019 at 5:36 PM Saul, Jean Paolo
<paolo(dot)saul(at)verizonconnect(dot)com> wrote:
> Using prepared and extended. No luck.
And your checkpoint settings?
The performance you're seeing is pretty bad for a server that has more
than 40GB of memory. I can get far superior performance on the same
benchmark with a relatively inexpensive workstation, at least on the
master branch.
Try these for a start if you're using default checkpoint settings, as
I suspect you are:
checkpoint_timeout=5min
min_wal_size=10GB
max_wal_size=40GB
wal_compression=on
backend_flush_after=0
checkpoint_flush_after=256kB
checkpoint_completion_target=0.9
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Saul, Jean Paolo | 2019-02-12 02:00:56 | Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes |
| Previous Message | Saul, Jean Paolo | 2019-02-12 01:36:33 | Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes |