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
