Re: GiST VACUUM
Heikki Linnakangas <hlinnaka@iki.fi>
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Michael Paquier <michael@paquier.xyz>, Thomas Munro <thomas.munro@enterprisedb.com>, Robert Haas <robertmhaas@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Костя Кузнецов <chapaev28@ya.ru>
Date: 2019-03-05T13:21:09Z
Lists: pgsql-hackers
On 05/03/2019 02:26, Andrey Borodin wrote: >> I also tried your amcheck tool with this. It did not report any >> errors. >> >> Attached is also latest version of the patch itself. It is the >> same as your latest patch v19, except for some tiny comment >> kibitzing. I'll mark this as Ready for Committer in the commitfest >> app, and will try to commit it in the next couple of days. > > That's cool! I'll work on 2nd step of these patchset to make > blockset data structure prettier and less hacky. Committed the first patch. Thanks for the patch! I did some last minute copy-editing on the comments, and fixed one little thing that we missed earlier: the check for "invalid tuples" that might be left over in pg_upgraded pre-9.1 indexes, was lost at some point. I added that check back. (It would be nice if GiST indexes had a metadata page with a version number, so we could avoid that work in the 99% of cases that that check is not needed, but that's a different story.) I'll change the status of this patch to "Waiting on Author", to reflect the state of the 2nd patch, since you're working on the radix tree blockset stuff. - Heikki
Commits
-
Use full 64-bit XID for checking if a deleted GiST page is old enough.
- fb5344c969af 12.0 landed
- 6655a7299d83 13.0 landed
-
Refactor checks for deleted GiST pages.
- e2e992c93145 12.0 landed
- 9eb5607e6993 13.0 landed
-
Delete empty pages during GiST VACUUM.
- 7df159a620b7 12.0 landed
-
Scan GiST indexes in physical order during VACUUM.
- fe280694d0d4 12.0 landed
-
Prevent GIN deleted pages from being reclaimed too early
- 52ac6cd2d0cd 12.0 cited