autovacuum default run with vacuum_index_cleanup and vacuum_truncate and related lock?

Поиск
Список
Период
Сортировка
От James Pang (chaolpan)
Тема autovacuum default run with vacuum_index_cleanup and vacuum_truncate and related lock?
Дата
Msg-id PH0PR11MB51917B6D0E1C97DA6EAAEC3FD62C9@PH0PR11MB5191.namprd11.prod.outlook.com
обсуждение исходный текст
Ответы Re: autovacuum default run with vacuum_index_cleanup and vacuum_truncate and related lock?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin

Hi,

It’s Postgres 13 version, we plan to migrate from Oracle to Postgres 13 on RHEL8.  One maintain job is about autovacuum, with default config,  autovacuum will do on tables with  “vacuum_index_cleanup” and “vacuum_truncate” option?   With both options, autovacuum woker will hold “access exclusive” lock when truncate empty blocks and cleanup index ?  if that’s true, how to handle autovacuum to reduce the lock blocking issue?

 

Thanks,

 

James

В списке pgsql-admin по дате отправления:

Предыдущее
От: Goti
Дата:
Сообщение: Re: Does aurora PostgreSQL use wal_buffers?
Следующее
От: "James Pang (chaolpan)"
Дата:
Сообщение: Disk IO wait event DataFileImmediateSync and DataFileSync