Re: pg_autovacuum crashes when query fails for temp tables

Christopher Kings-Lynne wrote:

> Does pg_autovacuum vacuum and analyze system catalog and TOAST tables
> properly?

Properly? I think so, that is to the best of my knowledge which is a
bit limited :-)

Toast Tables: pg_autovacuum doesn't do anything to toast tables
explicitly. I am not aware that they need to be considered, I believe
that if you vacuum table_foo which has an underlying toast table, then
vacuum "does the right thing". Am I wrong? Someone please enlighten me
if I am and I will fix.

System Tables: pg_autovacuum treats non-shared system tables just like
any other table. It monitors the activity and vacuums when it deems it
appropriate. As for shared system tables: In user databases they are
only analyzed by pg_autovacuum, while connected to template1,
pg_autovacuum will treat the shared tables as normal tables and vacuum
when appropriate.

Does all this sound kosher?

Thanks,

Matthew