On Tue, Mar 6, 2018 at 7:29 AM, Peter Geoghegan <pg@bowt.ie> wrote:
On Mon, Mar 5, 2018 at 5:48 PM, Claudio Freire <klaussfreire@gmail.com> wrote: > I believe PKs are a prime candidate for this optimization, and > expecting it to apply only when no concurrency is involved is severely > dumbing down the optimization.
Pavan justified the patch using a benchmark that only involved a single client -- hardly typical for a patch that changes the B-Tree code. If the benefits with many clients can be shown to matter, that will make this much more interesting to me.
Ok. I will repeat those tests with more number of clients and report back.
So I repeated the tests with 1,2,4 and 8 clients, each running the following statement and a total of 1024 transactions. So roughly 100M rows are inserted.
INSERT INTO testtab(b) SELECT generate_series(1,100000);