Re: Small improvement to compactify_tuples

Sokolov Yura <funny.falcon@postgrespro.ru>

View thread View on postgr.es

From: Sokolov Yura <funny.falcon@postgrespro.ru>

To: Alvaro Herrera <alvherre@2ndquadrant.com>

Cc: Heikki Linnakangas <hlinnaka@iki.fi>, pgsql-hackers@postgresql.org, Heikki Linnakangas <hlinnaka@gmail.com>

Date: 2017-05-15T15:23:12Z

Lists: pgsql-hackers

Attachments

0002-bufpage.c-simplify-PageRepairFragmentation.patch (text/x-diff) patch 0002
0001-storage-page-bufpage.c-improve-compactify_tuples-v02.patch (text/x-diff) patch v2-0001

Alvaro Herrera писал 2017-05-15 18:04:
> Please add these two patches to the upcoming commitfest,
> https://commitfest.postgresql.org/

Thank you for suggestion.

I've created https://commitfest.postgresql.org/14/1138/
As I could understand, I should attach both patches to single email
to be show correctly in commitfest topic. So I do it with this email.

Please, correct me, if I do something wrong.

With regards.
-- 
Sokolov Yura aka funny.falcon
Postgres Professional: https://postgrespro.ru
The Russian Postgres Company

Commits

Avoid looping through line pointers twice in PageRepairFragmentation().
- a9169f0200fc 11.0 landed
Reduce pinning and buffer content locking for btree scans.
- 2ed5b87f96d4 9.5.0 cited
Speed up in-memory tuplesorting.
- 337b6f5ecf05 9.2.0 cited