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  (Jakub Jedelsky <jakub.jedelsky@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jakub Jedelský
Дата:
Сообщение: [ADMIN] Autovacuum of pg_database
Следующее
От: Jakub Jedelsky
Дата:
Сообщение: Re: [ADMIN] Autovacuum of pg_database