| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Andres Freund <andres(at)2ndquadrant(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: truncating pg_multixact/members |
| Date: | 2014-02-13 20:44:13 |
| Message-ID: | 20140213204413.GV6342@eldon.alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Alvaro Herrera escribió:
> So here are two patches -- the first one, for 9.3 and HEAD, introduce
> the new aging variables and use them throughout vacuum and autovacuum,
> including per-table options; the second one adjusts the struct
> declarations to avoid the ABI break in VacuumStmt and StdRdOptions.
I forgot to ask: what opinions are there about
vacuum_multixact_freeze_table_age's default value? Right now I have 150
million, same as for Xids. However, it might make sense to use 300
millions, so that whole-table scans are not forced earlier than for Xids
unless consumption rate for multixacts is double the one for Xids.
I already have set autovacuum_multixact_freeze_max_age to 400 million,
i.e. double that for Xids. This means emergency vacuums will not take
place for multis, unless consumption rate is double that for Xids.
This seems pretty reasonable to me.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-02-13 20:49:08 | Re: BUG #9210: PostgreSQL string store bug? not enforce check with correct characterSET/encoding |
| Previous Message | Bruce Momjian | 2014-02-13 20:34:09 | Re: Auto-tuning work_mem and maintenance_work_mem |