| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Zhihong Yu <zyu(at)yugabyte(dot)com>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: pgsql: autovacuum: handle analyze for partitioned tables |
| Date: | 2021-04-21 23:06:49 |
| Message-ID: | 20210421230649.GA19244@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
On 2021-Apr-09, Robert Haas wrote:
> Does this need to worry about new partitions getting attached to a
> partitioned table, or old ones getting detached? (Maybe it does
> already, not sure.)
I was pinged because this is listed as an open item. I don't think it
is one. Handling ATTACH/DETACH/DROP is important for overall
consistency, of course, so we should do it eventually, but the fact that
autovacuum runs analyze *at all* for partitioned tables is an enormous
step forward from it not doing so. I think we should treat ATTACH/
DETACH/DROP handling as a further feature to be added in a future
release, not an open item to be fixed in the current one.
Now, if somebody sees a very trivial way to handle it, let's discuss it,
but *I* don't see it.
--
Álvaro Herrera Valdivia, Chile
"You're _really_ hosed if the person doing the hiring doesn't understand
relational systems: you end up with a whole raft of programmers, none of
whom has had a Date with the clue stick." (Andrew Sullivan)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yuzuko | 2021-04-21 23:30:52 | Re: pgsql: autovacuum: handle analyze for partitioned tables |
| Previous Message | Alvaro Herrera | 2021-04-21 22:40:19 | Re: pgsql: autovacuum: handle analyze for partitioned tables |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jehan-Guillaume de Rorthais | 2021-04-21 23:09:19 | Re: when the startup process doesn't |
| Previous Message | Alvaro Herrera | 2021-04-21 22:40:19 | Re: pgsql: autovacuum: handle analyze for partitioned tables |