Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes
Date
Msg-id CAH2-WzkMssT_X+GXjU_o19dS7y9wpruzOCFSYOLf1Sj1yxutrQ@mail.gmail.com
Whole thread Raw
In response to BUG #15609: synchronous_commit=off insert performance regression with secondary indexes  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes
List pgsql-bugs
On Mon, Feb 11, 2019 at 4:47 PM Saul, Jean Paolo
<paolo.saul@verizonconnect.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


pgsql-bugs by date:

Previous
From: "Saul, Jean Paolo"
Date:
Subject: Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes
Next
From: "Saul, Jean Paolo"
Date:
Subject: Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes