Postgres Pro
Downloads
Home   >   mailing lists

Re: Faster inserts with mostly-monotonically increasing values - Mailing list pgsql-hackers

From Pavan Deolasee
Subject Re: Faster inserts with mostly-monotonically increasing values
Date
Msg-id CABOikdNo1aR7U0gv_GOC-X69kta48-b+HLCnBL+-deE5PQag8Q@mail.gmail.com
Whole thread Raw
In response to Re: Faster inserts with mostly-monotonically increasing values  (Claudio Freire <klaussfreire@gmail.com>)
List pgsql-hackers
Tree view


On Wed, Mar 14, 2018 at 10:58 AM, Claudio Freire <klaussfreire@gmail.com> wrote:


I'm thinking there could be contention on some lock somewhere.

Can you attach the benchmark script you're using so I can try to reproduce it?


I am using a very ad-hoc script.. But here it is.. It assumes a presence of a branch named "btree_rightmost" with the patched code.

You will need to make necessary adjustments of course.

Thanks,
Pavan


--
 Pavan Deolasee                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: add queryEnv to ExplainOneQuery_hook
Next
From: Michael Paquier
Date:
Subject: Re: remove pg_class.relhaspkey