From: | momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian) |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql-server/contrib/pg_autovacuum Tag: REL7_4 ... |
Date: | 2003-12-01 23:20:00 |
Message-ID: | 20031201232000.47E06D1D458@svr1.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian(at)svr1(dot)postgresql(dot)org 03/12/01 19:19:55
Modified files:
contrib/pg_autovacuum: Tag: REL7_4_STABLE pg_autovacuum.c
pg_autovacuum.h
Log message:
I've run across a pretty serious problem with pg_autovacuum.
pg_autovacuum looses track of any table that's ever been truncated
(possibly other situations too). When i truncate a table it gets a
new relfilenode in pg_class. This is a problem because pg_autovacuum
assumes pg_class.relfilenode will join to pg_stats_all_tables.relid.
pg_stats_all_tables.relid is actallly the oid from pg_class, not the
relfilenode. These two values start out equal so pg_autovacuum works
initially, but it fails later on because of this incorrect assumption.
This patch fixes that problem. Applied to HEAD and 7.4.X.
Brian Hirt
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-12-02 00:27:00 | pgsql-server/ oc/src/sgml/ref/drop_operator.sg ... |
Previous Message | Bruce Momjian | 2003-12-01 23:19:34 | pgsql-server/contrib/pg_autovacuum pg_autovacu ... |