| From: | yuzuko <yuzukohosoya(at)gmail(dot)com> |
|---|---|
| To: | Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com> |
| Cc: | Daniel Gustafsson <daniel(at)yesql(dot)se>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Greg Stark <stark(at)mit(dot)edu> |
| Subject: | Re: Autovacuum on partitioned table (autoanalyze) |
| Date: | 2020-10-23 06:12:51 |
| Message-ID: | CAKkQ508g4zNhw36rZ5Cjt9ANnrerGujP5cHfN2nrwO6JywDVhg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
I reconsidered a way based on the v5 patch in line with
Horiguchi-san's comment.
This approach is as follows:
- A partitioned table is checked whether it needs analyze like a plain
table in relation_needs_vacanalyze(). To do this, we should store
partitioned table's stats (changes_since_analyze).
- Partitioned table's changes_since_analyze is updated when
analyze a leaf partition by propagating its changes_since_analyze.
In the next scheduled analyze time, it is used in the above process.
That is, the partitioned table is analyzed behind leaf partitions.
- The propagation process differs between autoanalyze or plain analyze.
In autoanalyze, a leaf partition's changes_since_analyze is propagated
to *all* ancestors. Whereas, in plain analyze on an inheritance tree,
propagates to ancestors not included the tree to avoid needless counting.
Attach the latest patch to this email.
Could you check it again please?
--
Best regards,
Yuzuko Hosoya
NTT Open Source Software Center
| Attachment | Content-Type | Size |
|---|---|---|
| v10_autovacuum_on_partitioned_table.patch | application/octet-stream | 22.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyotaro Horiguchi | 2020-10-23 06:20:20 | Re: Enumize logical replication message actions |
| Previous Message | Luc Vlaming | 2020-10-23 05:51:16 | Re: allow partial union-all and improve parallel subquery costing |