Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes

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 00:49:23
Message-ID: CAH2-WzkMssT_X+GXjU_o19dS7y9wpruzOCFSYOLf1Sj1yxutrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Feb 11, 2019 at 4:47 PM Saul, Jean Paolo
<paolo(dot)saul(at)verizonconnect(dot)com> wrote:
> Aside from the ports:
>
> listen_addresses = '*'
> max_connections = 300
> max_wal_senders = 0 -- (on PG11)
> synchronous_commit = off

You mean shared_buffers is set to the default?

I don't think that that's an interesting test case. If shared_buffers
is ridiculously small, then there is little that we can take away from
your benchmark, or any benchmark like it.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Saul, Jean Paolo 2019-02-12 01:19:30 Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes
Previous Message Saul, Jean Paolo 2019-02-12 00:47:17 Re: BUG #15609: synchronous_commit=off insert performance regression with secondary indexes