Faster inserts with mostly-monotonically increasing values

Title

Topic

Performance

Created

2018-02-02 10:32:14

Last modified

2018-03-26 12:11:47 (6 years, 7 months ago)

Latest email

2018-04-10 14:20:16 (6 years, 7 months ago)

Status

2018-03: Committed

Target version

Authors

Pavan Deolasee (pavan)

Reviewers

Claudio Freire (klaussfreire)Become reviewer

Committer

Andrew Dunstan (adunstan)

Links

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/1503
git checkout commitfest/cf/1503

Emails

Faster inserts with mostly-monotonically increasing values: First at 2017-12-31 06:44:02 by Pavan Deolasee <pavan.deolasee at gmail.com>
Latest at 2018-04-10 14:20:16 by Pavan Deolasee <pavan.deolasee at gmail.com>
Latest attachment (pg_btree_target_block_v4.patch) at 2018-03-23 09:57:15 from Pavan Deolasee <pavan.deolasee at gmail.com>
    Attachment (pg_btree_target_block_v4.patch) at 2018-03-23 09:57:15 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (pg_btree_target_block_v3.patch) at 2018-03-22 06:29:14 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (0001-Ignore-last-offset.patch) at 2018-03-15 02:21:59 from Claudio Freire <klaussfreire at gmail.com> (Patch: Yes)
    Attachment (pg_btree_insert_benchmark.sh) at 2018-03-14 05:44:24 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: No)
    Attachment (pg_btree_target_block_v2.patch) at 2018-03-14 04:36:07 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)
    Attachment (pg_btree_target_block_v1.patch) at 2017-12-31 06:44:02 from Pavan Deolasee <pavan.deolasee at gmail.com> (Patch: Yes)

History

When	Who	What
2018-03-26 12:11:47	Andrew Dunstan (adunstan)	Closed in commitfest 2018-03 with status: Committed
2018-03-25 00:30:32	Andrew Dunstan (adunstan)	Added adunstan as committer
2018-03-06 15:39:28	Claudio Freire (klaussfreire)	Added klaussfreire as reviewer
2018-02-02 10:32:38	Pavan Deolasee (pavan)	Changed authors to Pavan Deolasee (pavan)
2018-02-02 10:32:14	Pavan Deolasee (pavan)	Attached mail thread CABOikdM9DrupjyKZZFM5k8-0RCDs1wk6JzEkg7UgSW6QzOwMZw@mail.gmail.com
2018-02-02 10:32:14	Pavan Deolasee (pavan)	Created patch record