Re: New gist vacuum.

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Костя Кузнецов <chapaev28(at)ya(dot)ru>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: New gist vacuum.
Date: 2017-12-28 11:37:48
Message-ID: 9F1C73D0-5CB2-40EE-A910-010365AAA269@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi hackers!
> 19 дек. 2017 г., в 15:58, Andrey Borodin <x4mmm(at)yandex-team(dot)ru> написал(а):
> Here is the patch that deletes pages during GiST VACUUM.

Here is new version of the patch for GiST VACUUM.
There are two main changes:
1. During rescan for page deletion only know to be recently empty pages are rescanned.
2. I've re-implemented physical scan with array instead of hash table.

Thanks!
Merry Christmas and happy New Year.

Best regards, Andrey Borodin.

Attachment Content-Type Size
0001-Delete-pages-during-GiST-VACCUM.patch application/octet-stream 13.9 KB
0002-Physical-GiST-scan.patch application/octet-stream 11.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Victor Yagofarov 2017-12-28 12:02:42 Why standby restores some WALs many times from archive?
Previous Message John Naylor 2017-12-28 11:26:23 Re: WIP: a way forward on bootstrap data