| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Melvin Davidson <melvin6925(at)gmail(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Michael H <michael(at)wemoto(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |
| Date: | 2015-08-18 18:02:07 |
| Message-ID: | 20150818180207.GJ5232@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I wrote:
> One thing to look at is the rate of WAL generation for a set number of
> transactions. Maybe the later releases are generating more WAL due to
> multixacts, for instance (prior to 9.3 these weren't wal-logged.)
FWIW a very easy way to measure this is to look at the output of
"pg_xlogdump -r MultiXact" for the WAL generated during the testing
period.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2015-08-18 18:44:54 | Re: How to tune my new server |
| Previous Message | Alvaro Herrera | 2015-08-18 18:00:11 | Re: CentOS - PostgreSQL 9.2.13 -> 9.4 |