Re: Small improvement to compactify_tuples

Sokolov Yura <funny.falcon@postgrespro.ru>

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>, pgsql-hackers-owner@postgresql.org

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

Lists: pgsql-hackers

Attachments

improve-repairing-fragmentation.patch (text/x-diff) patch 0001

Sokolov Yura писал 2017-05-15 18:23:
> 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.

Looks like it should be single file.

-- 
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