Eugeny N Dzhurinsky <bofh@redwerk.com> writes:
> but it seems pg_autovacuum does not do vacuuming on system tables.
There was a bug awhile back whereby autovac failed to notice temp table
cleanup at connection end --- maybe you need to update?
regards, tom lane