Tom Lane wrote:
>I'm having some second thoughts about allowing VACUUM on a toast table
>independently of its parent table --- it's a bit scary to be messing
>with the toast table when we have no lock at all on the parent. It
>might work OK, but I'm not sure I want to take the risk. If we simply
>expose toast tables in the stats views, what has to be done to
>autovacuum to get it to work properly? ("Properly" in this case would
>mean "fire a VACUUM on the parent table if either it or its toast table
>look like they need vacuumed".) Is this much worse than what you
>say above?
>
>
Oh well.... It sounded like a good idea :-)
No it's not much worse, in fact handling this is much like the way we
handle vacuum analyze and analyze only separately. So the
infrastructure is mostly there, it will require some tweaks to the
patch, but nothing large.
Matt