Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Erik Jones <erik(at)myemma(dot)com>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Date: 2007-06-01 14:49:22
Message-ID: 1180709361.15569.103.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> How would reindexing a table imply hours of downtime?

Simply, all meaningful activities on this system will sooner or later
insert into this table :-)

So given that we use a connection pool we end up pretty soon with all
connections waiting for an insert on this table, and at that point
nothing else will work either.

Cheers,
Csaba.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marco Colombo 2007-06-01 14:50:32 Re: PITR Base Backup on an idle 8.1 server
Previous Message Frank Wittig 2007-06-01 14:48:30 Re: warm standby server stops doing checkpointsafterawhile