| 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: | Whole Thread | Raw Message | 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 |
| 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 |