Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a7XPa-0007eV-UU for pgsql-performance@arkaria.postgresql.org; Fri, 11 Dec 2015 23:47:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a7XPZ-0005np-RE for pgsql-performance@arkaria.postgresql.org; Fri, 11 Dec 2015 23:47:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a7XNp-0003p0-7u for pgsql-performance@postgresql.org; Fri, 11 Dec 2015 23:45:53 +0000 Received: from mail-bl2on0100.outbound.protection.outlook.com ([65.55.169.100] helo=na01-bl2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a7XNk-0002eE-UP for pgsql-performance@postgresql.org; Fri, 11 Dec 2015 23:45:52 +0000 Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from aca8637d.ipt.aol.com (162.199.209.141) by SN1PR11MB0686.namprd11.prod.outlook.com (10.163.207.144) with Microsoft SMTP Server (TLS) id 15.1.337.19; Fri, 11 Dec 2015 23:45:43 +0000 Subject: Re: checkpoints, proper config To: Tory M Blue , "Joshua D. Drake" References: <5669B47B.9010504@commandprompt.com> <5669D9E6.8050104@commandprompt.com> CC: "pgsql-performance@postgresql.org" From: Jim Nasby Message-ID: <566B6024.4030801@BlueTreble.com> Date: Fri, 11 Dec 2015 17:45:40 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:38.0) Gecko/20100101 Thunderbird/38.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [162.199.209.141] X-ClientProxiedBy: BY1PR17CA0001.namprd17.prod.outlook.com (25.162.18.139) To SN1PR11MB0686.namprd11.prod.outlook.com (25.163.207.144) X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0686; 2:5AFecNlr6KC9M+AynVYrrgIec5DhvS3VATjwQNetqKhGlsB2lbw2XWGyYAvbf1QqtP7Pqm5MgSk/5QW9JJVhAcrfUHnU2118f+0aQb/RiPm+11MNI/g1GF0L0lU3b8Bd88cjP4Cp2IRwYRZPoUPdyw==; 3:ThcCGDyfs2sqfA5BhUoQ7ZYuB/q7FCo6u6H5+VjJWiZIP3AMhzK+dqQ4jXxC6YK+1TgCJn8LGhHhSavbOfTZ4pjuugCsKaIpWi0QnntZ37e1cGEMbosari+3VkkvXbX+; 25:Hjocno4f7HHjzDVtq3p2AFmwqm1+7u1iiaEZ7mhvaV589It/tnQWe1ab47KIU11w36zoWMCo+8pUc3UaGUJtGociPVr0msz2bws8AWvnmpwqnRT+h1mRnbXKws0mhr6yamyp3U7R0hLWTATDkAJW+ugwVlYNWig860LVx47kRO1XjEdgv9+tCjvPUxvzBoP5EjfyQUqD86H9kX8KvDFsgTrxt4REQc8vXLoLx+28K45GvDAwutvxSLeYmdcIXODPZtWGlZJgeEWtIXJTHlYHQg==; 20:BFup8pPBZwOZQeG2BKDmveSuNpulflsPHXloMNmL+lupWAKgaFGyhZWIIQmfnVHjBj9lpIYUUzgaMUOft8EOmtGW0mEThov7yPNrk7aoW3MK87OY6mC0/F/AiAwTbbJfu6eSZM66injLuKP6Ql6XqUixcN3TO+hrWDCDkQxaJ3A= X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:SN1PR11MB0686; X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(601004)(2401047)(5005006)(520078)(8121501046)(3002001)(10201501046); SRVR:SN1PR11MB0686; BCL:0; PCL:0; RULEID:; SRVR:SN1PR11MB0686; X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0686; 4:zbhglloplHI+jZo9BsIddjUla6ZfnQDAUKVxzXx3ULiSz9SNSLn5/pzfSWGAojiqlT/5F9Oinf4h4snQaprrIsf3op/rQk0ggVB68pkfm7GpnJb83mqpDhElawzepYarYDtVcsPSJw0E+87g2VD/W3plolMWhy5Ze/1JU0LZvjocEHMOy7+VMBkFa6JTOE1zeuPkrsCVvIHMvo5zCiIPmYeC6FHhE4vHcYPMgOOyOzf4mkyCCpP9ztgUznXbNu5pkP1+YeR1H+fxZV1HrUw/CX8ronlKRwO5hqMdKfpQCA0Cfprg00yc79Dturw3C485CWizm8hQ9UA7mAbk4DKNtqx0/AxVsh2fnCFrdIkk9A1RW+k7dLiBCfc/rIUJZZh9 X-Forefront-PRVS: 0787459938 X-Forefront-Antispam-Report: SFV:NSPM; SFS:(10009020)(6009001)(199003)(189002)(377454003)(479174004)(24454002)(15975445007)(65956001)(97736004)(5004730100002)(54356999)(64126003)(33656002)(65816999)(189998001)(86362001)(42186005)(87976001)(76176999)(5001770100001)(59896002)(66066001)(36756003)(47776003)(23676002)(77096005)(92566002)(106356001)(4001350100001)(93886004)(1096002)(87266999)(122386002)(80316001)(101416001)(50986999)(586003)(2950100001)(3846002)(105586002)(5008740100001)(19580395003)(50466002)(6116002)(65806001)(230700001)(40100003)(83506001)(85282002)(336755003)(18886065003); DIR:OUT; SFP:1101; SCL:1; SRVR:SN1PR11MB0686; H:aca8637d.ipt.aol.com; FPR:; SPF:None; PTR:InfoNoRecords; A:1; MX:1; LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtTTjFQUjExTUIwNjg2OzIzOm9abi8vV1QvNW9nQkYwUVorNjlhc1htUmJt?= =?utf-8?B?UHVsRm4rd0VEelBrZ0w5WldaeW5JWE5OQUMwaDZ2WS9jeFo0c2dIdTNYaUdu?= =?utf-8?B?WmRBUVJUZ3pyQjNZbzdmNnZLY2RMcWwxM2ZwQklZYmlHdVVjb2NTL3BpdkEy?= =?utf-8?B?TTdMYXh4V0ZGSHV5K1JZVnVpUEdiSlFmZXJ2N0gyU1ZQaFJUbWRzelJ2WXkx?= =?utf-8?B?NjdwSnhGeHF3SmZUVE1kVHhpVlRPWmtiODZlZXo0SlE4U2Y2NDZ5TmdUd0kr?= =?utf-8?B?SlVvNUJDMithTnJJVHVVRmpFUzRLWE5zRkpJd3RiMlpoVHhFemMzZmY2VWp4?= =?utf-8?B?ZUp6Z3dRN29OWC9pVnJYRnRTMThsZmxheFAzc0VFNnY4cmpYdktlOVdPalhm?= =?utf-8?B?YVd5Tld1aTF4Uk1wazltbCsvbVpDc1JGQW5ZRGxRMVZoVWtYUEFkOHdhV1Zp?= =?utf-8?B?WmpVS0RRK3hmQVpyMWpaOWxJR2lXdVc4NnpRY2Y1aUI3NldyV3RaZmQ2M0Vu?= =?utf-8?B?bHRoVjlKV3p3VlBjUTJoaG5pT0YyVm5JWmR0YUdhSzFkRm55NmFaTysyZGQ2?= =?utf-8?B?RkdMS1k2OWw5NzBLcWtmdHFkREpFbVBGNnVlZmpWZzc1bEFFVHdyRm02Z2kv?= =?utf-8?B?NWZRbllWdVJReDdQU3YzdDR0YTJtQlYySHpmT2xCSDBESzVhVEdoaEtzVkxS?= =?utf-8?B?UGQ3eUZpdXVWYVN6TkNJWURuTXl6QU5PQ3B0WTVWTjRQTHpKWFRxaUxRVWgz?= =?utf-8?B?UENvY2VhdTlaWk1yOW55WHJxRkFGcHlwTHd2NnBIenV6d0kxYzZaR212MHBk?= =?utf-8?B?S0dxRWh0TThLay9RQWF6YjdJOGRaRWRyZDVWVlgrV3NzZ3VtN3ZkL1RhOWdJ?= =?utf-8?B?K3VSMW8yZmNIenJtNm5Rd016NFRCQ01neGJmZ2JjY0xDbDFQUmcvU2QvM2pa?= =?utf-8?B?OEkwZ2EvL2ZqdWQ3aUQydW0wVjUzMEE2VlFwYWRLNk0raFRHeVRIWnQ0Ry9Q?= =?utf-8?B?ZERhQm1obWN1S3hXTXFIdjZjU25kTUNhRVBHS0VqS3R4cGtNZHA3WlphYjVi?= =?utf-8?B?dEpkZFNOa3VHa3pra215eGpFZXFaa1d3WExVcFZHeTlXOXpTaUxLNTB1NXBy?= =?utf-8?B?U2RNQk56bHFZTC9uVUFGdE9XSmRDS05Yb2t0Tm5jc0V0ZTJkNE5ES2hIQnd3?= =?utf-8?B?dHh3ajZJQTNkRnBjRy8zcStURVc1eE5tUU4rSDJjdVhTRC95aVdaYzFIVVJB?= =?utf-8?B?dER3Z3pLc1o3YW9LcEVUWUpQM1BoNjFTR0VnN05Xc3VwUDR0MHpOZXU4Ykxr?= =?utf-8?B?RStTcktkVERHZUhMdFg4RWZBbm0zbExpVlNQRVV3OGhMT3k3QmNYQlNMbTZy?= =?utf-8?B?NkNpNUQ5ZHJKMHQzNzlxaGZpRHBPbnNjeXkwaFRVMjBDd1llaDYyRFpzUzl2?= =?utf-8?B?MERXU3FlRGhVZHhwNVp3bEhKbHhvL3NKN3JTNW9yRlZlSXFnUDZqOUxlT3pC?= =?utf-8?B?TDlWdUorNjJFeUcyQitucnFYYkFLNmFicUtBQ0o2TzVoeW5mRndaek5JcWpt?= =?utf-8?B?U1ZnMEJMWmsvSmVqT3M2QjIzL0t4YjVwRHJNZ2lIdG02QmN5NkZISUFGMStl?= =?utf-8?B?bVR1ZkNmSTliRkl0cjVYcVRxcndqaWR0Szl3WGVzQ0VER0kzdmcrSEQzbk9h?= =?utf-8?B?UzlLb0NsNU9wcXE0b2FnMlZ5SjRpZ0xTdFhWNlJzcHZETE5HWitpWkdwSkRB?= =?utf-8?Q?bRRSryAn6n/f5IWBS9QdRXItaEdGEsNzU0apk=3D?= X-Microsoft-Exchange-Diagnostics: 1; SN1PR11MB0686; 5:EGZAHautEGz9B+nw+RrpkgJo9tk0phDRTiTxQw5dTcNvn/HAU5lrcPl6T+faPkqDTc6tG/5+gBbZP8nxghI6t17FELKh+8U4a51S1cTFTEGpBGj0lCnk9rG6qA3+63ONMgOHeY1CIZ9ZIlfo7Lh9Ew==; 24:4ch+SYVn5Kt2xKJ3qO/DhACNYYTBAYE7jjhCJSNNhl25mkVXDaS/nA0yh+TyaisGoj8ugPmnPCD7yCnP+8MywJLHQgRk3jLnhf7PTiCz6w8= SpamDiagnosticOutput: 1:23 SpamDiagnosticMetadata: NSPM X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 11 Dec 2015 23:45:43.9606 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1PR11MB0686 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance