Re: [HACKERS] Block level parallel vacuum
| От | Sergei Kornilov |
|---|---|
| Тема | Re: [HACKERS] Block level parallel vacuum |
| Дата | |
| Msg-id | 17809001578651662@vla1-422f52264539.qloud-c.yandex.net обсуждение исходный текст |
| Ответ на | Re: [HACKERS] Block level parallel vacuum (Amit Kapila <amit.kapila16@gmail.com>) |
| Ответы |
Re: [HACKERS] Block level parallel vacuum
Re: [HACKERS] Block level parallel vacuum |
| Список | pgsql-hackers |
Hi
Thank you for update! I looked again
(vacuum_indexes_leader)
+ /* Skip the indexes that can be processed by parallel workers */
+ if (!skip_index)
+ continue;
Does the variable name skip_index not confuse here? Maybe rename to something like can_parallel?
Another question about behavior on temporary tables. Use case: the user commands just "vacuum;" to vacuum entire
database(and has enough maintenance workers). Vacuum starts fine in parallel, but on first temporary table we hit:
+ if (RelationUsesLocalBuffers(onerel) && params->nworkers >= 0)
+ {
+ ereport(WARNING,
+ (errmsg("disabling parallel option of vacuum on \"%s\" --- cannot vacuum temporary tables in
parallel",
+ RelationGetRelationName(onerel))));
+ params->nworkers = -1;
+ }
And therefore we turn off the parallel vacuum for the remaining tables... Can we improve this case?
regards, Sergei
В списке pgsql-hackers по дате отправления: