[postgresql 9.3.5] autovacuums stuck on non-existent pg_toast tables

Hi everyone,

Two weeks ago, one of our Postgres databases crashed violently and had to be
brought up again. This certainly resulted in some lost pg_clog files, and we
had to zero-fill them in one by one to get autovacuum up and running again.

Now, we have two autovacuuming processes constantly stuck at two pg_toast
tables that are nonexistent:

autovacuum: VACUUM pg_toast.pg_toast_455742374 (runs up to twelve hours with
no progress)

# select 455742374::regclass;
regclass
-----------
455742374
(1 row)

whereas normally for a pg_toast table we should have something like

# select 1371237940::regclass;
regclass
-------------------------------------------------
performance_report_parallel.campaigns_summary_p
(1 row)

The result is that we are down to just one autovacuum worker, which is
evidently not enough to help our database oiled and running. :"(

Our autovacuum paramters are all using default values.

Any help would be greatly appreciated. Thank you!

--
View this message in context: http://postgresql.nabble.com/postgresql-9-3-5-autovacuums-stuck-on-non-existent-pg-toast-tables-tp5839397.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.