| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Csaba Nagy <nagy(at)ecircle-ag(dot)com> |
| Cc: | Erik Jones <erik(at)myemma(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 15:54:05 |
| Message-ID: | 20070601155405.GG4503@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Csaba Nagy wrote:
> On Fri, 2007-06-01 at 17:40, Alvaro Herrera wrote:
> > Huh, why do you say that it doesn't need any vacuuming?
>
> This table is only inserted and rarely deleted, so other than the XID
> wraparound vacuuming it is not critical. Of course it will need vacuum
> finally, but it can survive months without it - or till the XID
> wraparound occurs, which I can't estimate yet if in danger or not... how
> could I check that ? (I can probably find the answer if looking harder
> though).
select age(datfrozenxid) from pg_database where datname = 'your database'
2 billions and you are screwed. Autovacuum starts panicking way before
that, to have enough slack.
--
Alvaro Herrera http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"Un poeta es un mundo encerrado en un hombre" (Victor Hugo)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Fitzpatrick | 2007-06-01 16:02:20 | Restoring 8.2 to 8.0 |
| Previous Message | gonzales | 2007-06-01 15:51:02 | Re: Slightly OT. |