Dushyanth escribió: > # autovacuum processes > > postgres 16508 9.2 0.1 2310836 37984 ? Ds 09:58 0:09 \_ postgres: > autovacuum process db1 > postgres 19626 7.2 0.0 2289524 27704 ? Ds 10:09 0:03 \_ postgres: > autovacuum process db1 > postgres 20861 7.8 0.0 2298844 31028 ? Ds 10:13 0:08 \_ postgres: > autovacuum process db1 > postgres 21673 6.1 0.1 2336904 33400 ? Ds 10:16 0:12 \_ postgres: > autovacuum process db1 > postgres 21673 6.2 0.1 2339840 57400 ? Ds 10:16 0:31 \_ postgres: > autovacuum process db1 > postgres 13597 11.6 0.0 2358352 29936 ? Ds 17:12 0:20 \_ postgres: > autovacuum process db2 > postgres 13597 8.7 0.1 2358352 39056 ? Ds 17:12 0:41 \_ postgres: > autovacuum process db2 > postgres 13597 7.8 0.1 2363924 45540 ? Ds 17:12 1:01 \_ postgres: > autovacuum process db2
Something is seriously wrong here -- there should be only one autovacuum process ever in 8.2. Can you show a more complete ps tree, and perhaps include PPID in the listing? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general