diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2009-02-09 20:57:59 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2009-02-09 20:57:59 +0000 |
| commit | 834a6da4f72dc8e1bf95e5158033c54369df0cc5 (patch) | |
| tree | 179f879f9ba95fac5a68f3033f7a02236c09af4f /src/include/utils/rel.h | |
| parent | 57b10ebcd4896767576f25d3bd9a62382d740f02 (diff) | |
Update autovacuum to use reloptions instead of a system catalog, for
per-table overrides of parameters.
This removes a whole class of problems related to misusing the catalog,
and perhaps more importantly, gives us pg_dump support for the parameters.
Based on a patch by Euler Taveira de Oliveira, heavily reworked by me.
Diffstat (limited to 'src/include/utils/rel.h')
| -rw-r--r-- | src/include/utils/rel.h | 18 |
1 files changed, 17 insertions, 1 deletions
diff --git a/src/include/utils/rel.h b/src/include/utils/rel.h index ffb2b8530d3..a3aaf69e2f1 100644 --- a/src/include/utils/rel.h +++ b/src/include/utils/rel.h @@ -7,7 +7,7 @@ * Portions Copyright (c) 1996-2009, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/utils/rel.h,v 1.111 2009/01/01 17:24:02 momjian Exp $ + * $PostgreSQL: pgsql/src/include/utils/rel.h,v 1.112 2009/02/09 20:57:59 alvherre Exp $ * *------------------------------------------------------------------------- */ @@ -214,10 +214,26 @@ typedef struct RelationData * be applied to relations that use this format or a superset for * private options data. */ + /* autovacuum-related reloptions. */ +typedef struct AutoVacOpts +{ + bool enabled; + int vacuum_threshold; + int analyze_threshold; + int vacuum_cost_delay; + int vacuum_cost_limit; + int freeze_min_age; + int freeze_max_age; + int freeze_table_age; + float8 vacuum_scale_factor; + float8 analyze_scale_factor; +} AutoVacOpts; + typedef struct StdRdOptions { int32 vl_len_; /* varlena header (do not touch directly!) */ int fillfactor; /* page fill factor in percent (0..100) */ + AutoVacOpts autovacuum; /* autovacuum-related options */ } StdRdOptions; #define HEAP_MIN_FILLFACTOR 10 |