| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Tory M Blue <tmblue(at)gmail(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: checkpoints, proper config |
| Date: | 2015-12-11 23:45:40 |
| Message-ID: | 566B6024.4030801@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 12/10/15 2:58 PM, Tory M Blue wrote:
> This is a slony slave node, so I'm not too worried about this particular
> host losing it's data, thus fsync is off,
The Amazon RDS team actually benchmarked fsync=off vs sync commit off
and discovered that you get better performance turning sync commit off
and leaving fsync alone in some cases. In other cases the difference
isn't enough to be worth it.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2015-12-11 23:47:36 | Re: checkpoints, proper config |
| Previous Message | Rick Otten | 2015-12-11 22:09:46 | Re: partitioned table set and indexes |