Autovacuum on Partitioned Tables

Поиск
Список
Период
Сортировка
От Ryan Ruenroeng
Тема Autovacuum on Partitioned Tables
Дата
Msg-id CAEuohQp_iK8jKceQ1BUKZWtzhz4F=utke1WcYqK31ZAV4FV-Og@mail.gmail.com
обсуждение исходный текст
Ответы Re: Autovacuum on Partitioned Tables  (Ron <ronljohnsonjr@gmail.com>)
Re: Autovacuum on Partitioned Tables  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Hello there!

There is a statement in the Postgres Docs: "Partitioned tables are not processed by autovacuum."

What does the above statement mean?
Does autovacuum not process both the parent and the child tables in a partition relationship? 

What is the definition of a partitioned table?

I have a table with 50+ million rows that gets data added to/wiped from it every 90 days. We are planning to break this table into a few thousand partitions. More partitions will likely be added in the future, but we don't have plans to delete any of the partitions. Will we need to manually track the statistics of these partitions and manually vacuum the tables or will autovacuum help to manage them?

Best,
Ryan

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

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should