Postgres Pro
Downloads
Home   >   mailing lists

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-Wznca0WL6QA_DacP7YAA4xAXR0xOe=pW+jCi3KPpnJ=0kA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15609: synchronous_commit=off insert performance regressionwith secondary indexes  ("Saul, Jean Paolo" <paolo.saul@verizonconnect.com>)
List pgsql-bugs
Tree view 
On Tue, Feb 12, 2019 at 5:48 PM Saul, Jean Paolo
<paolo.saul@verizonconnect.com> wrote:
> Does having < four distinct values in the btree index have any known significance wrt to btree performance?

Not that I'm aware of, or have been able to ascertain through testing.

-- 
Peter Geoghegan

pgsql-bugs by date:

Previous
From: Chris Snook
Date:
Subject: Re: Occasional 9.6.10 PMChildFlags fatal error, possibly due to >2parallel gathers
Next
From: Dean Rasheed
Date:
Subject: Re: BUG #15623: Inconsistent use of default for updatable view