Hi!
> 28 дек. 2017 г., в 16:37, Andrey Borodin <x4mmm@yandex-team.ru> написал(а):
> 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.
There is one more minor spot in GiST VACUUM. It takes heap tuples count for statistics for partial indexes, while it
shouldnot.
If gistvacuumcleanup() is not given a statistics gathered by gistbulkdelete() it returns incorrect tuples count for
partialindex.
Here's the micropatch, which fixes that corner case.
To reproduce this effect I used this query:
create table y as select cube(random()) c from generate_series(1,10000) y; create index on y using gist(c) where c~>1 >
0.5;
vacuum verbose y;
Before patch it will report 10000 tuples, with patch it will report different values around 5000.
I do not know, should I register separate commitfest entry? The code is very close to main GiST VACUUM patch, but
solvesa bit different problem.
Best regards, Andrey Borodin.
