On Fri, 2007-08-03 at 18:56 +0100, Gregory Stark wrote: > Actually, we happen to be running into a situation here where we need more > logging. We need to understand why autovacuum isn't considering logging this > table: > > relid | schemaname | relname | seq_scan | seq_tup_read | idx_scan | > idx_tup_fetch | n_tup_ins | n_tup_upd | n_tup_del | n_live_tup | n_dead_tup | > last_vacuum | last_autovacuum | last_analyze | > last_autoanalyze > -------+------------+------------+----------+--------------+----------+---------------+-----------+-----------+-----------+------------+------------+-------------+-------------------------------+--------------+------------------------------- > 16436 | public | stock | 0 | 0 | 45929274 | > 45928278 | 0 | 12116286 | 0 | 25036190 | 12723033 | > | | | 2007-08-01 > 17:24:30.796874-07 > > It looks like there are some DEBUG3 messages which would be useful but I don't > know of any convenient way to change the log level in autovacuum workers.
It also appears that only a single autovacuum daemon active at any one time, which is also weird when we are supposed to have 3. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly