Re: autovacuum doesnt run on the pg_toast_id table

On Thu, Jan 17, 2019 at 07:28:52PM +0200, Mariel Cherkassky wrote:
...
> Now, I realized from the autovacuum
> logging, that when autovacuum runs on the original table (A) it doesn't
> necessary run on the toasted table and this is very weird.
...
> Any idea why the autovacuum doesnt vacuum both tables ?

It *does* vacuum both, just not *necessarily*, as you saw.

The toast is a separate table, so it's tracked separately.

Note that:
|If a table parameter value is set and the
|equivalent <literal>toast.</literal> parameter is not, the TOAST table
|will use the table's parameter value.

You could look in pg_stat_all_tables, to see how frequently the toast is being
autovacuumed relative to its table.

Justin