Re: [ADMIN] Autovacuum of pg_database
От | Tom Lane |
---|---|
Тема | Re: [ADMIN] Autovacuum of pg_database |
Дата | |
Msg-id | 15834.1494869368@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | [ADMIN] Autovacuum of pg_database (Jakub Jedelský <jakub.jedelsky@gmail.com>) |
Ответы |
Re: [ADMIN] Autovacuum of pg_database
|
Список | pgsql-admin |
=?UTF-8?Q?Jakub_Jedelsk=C3=BD?= <jakub.jedelsky@gmail.com> writes: > The problem (can) occurs when the pg_database table hits > `autovacuum_freeze_max_age` and I'm able to reporoduce it (but not always) > with this stupid reproducer: > * set autovacuum_freeze_min_age to it's minimum - 100000 > * generating ~ 1000 DBs > * make some transactions to almost hit `autovacuum_freeze_max_age` > * `vacuum freeze` all tables in all databases except pg_database > * run a few transactions to hit `autovacuum_freeze_max_age` I tried to reverse-engineer a test case out of this description, without much success. If you have a script that can reproduce the problem (even if not 100% success rate), could you share it? regards, tom lane
В списке pgsql-admin по дате отправления: