Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum
Date
Msg-id 1180709361.15569.103.camel@coppola.muc.ecircle.de
Whole thread Raw
In response to Re: Autovacuum keeps vacuuming a table disabled in pg_autovacuum  (Erik Jones <erik@myemma.com>)
List 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.


pgsql-general by date:

Previous
From: Frank Wittig
Date:
Subject: Re: warm standby server stops doing checkpointsafterawhile
Next
From: Marco Colombo
Date:
Subject: Re: PITR Base Backup on an idle 8.1 server