Re: New gist vacuum.
Alexander Korotkov <a.korotkov@postgrespro.ru>
From: Alexander Korotkov <a.korotkov@postgrespro.ru>
To: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>, Костя Кузнецов <chapaev28@ya.ru>, Jeff Janes <jeff.janes@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>
Date: 2018-01-15T18:42:26Z
Lists: pgsql-hackers
Hi! On Thu, Dec 28, 2017 at 2:37 PM, Andrey Borodin <x4mmm@yandex-team.ru> wrote: > > 19 дек. 2017 г., в 15:58, Andrey Borodin <x4mmm@yandex-team.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. > I'm very glad this patch isn't forgotten. I've assigned to review this patch. My first note on this patchset is following. These patches touches sensitive aspects or GiST and are related to complex concurrency issues. Thus, I'm sure both of them deserve high-level description in src/backend/access/gist/README. Given this description, it would be much easier to review the patches. ------ Alexander Korotkov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company
Commits
-
Make gistvacuumcleanup() count the actual number of index tuples.
- ccd650430db6 10.4 landed
- 947f06c6224e 9.4.18 landed
- 81b9b5ce490a 11.0 landed
- 6b56f07525a0 9.3.23 landed
- 529137cac9a8 9.6.9 landed
- 46d98da43e56 9.5.13 landed