Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ctzZP-0004X6-UP for pgsql-admin@arkaria.postgresql.org; Fri, 31 Mar 2017 16:38:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ctzZP-0003Qa-Gz for pgsql-admin@arkaria.postgresql.org; Fri, 31 Mar 2017 16:38:39 +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_2) (envelope-from ) id 1ctzXe-0000HX-20 for pgsql-admin@postgresql.org; Fri, 31 Mar 2017 16:36:50 +0000 Received: from forward7j.cmail.yandex.net ([5.255.227.108]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ctzXb-0002AC-3C for pgsql-admin@postgresql.org; Fri, 31 Mar 2017 16:36:49 +0000 Received: from mxback9m.mail.yandex.net (mxback9m.mail.yandex.net [IPv6:2a02:6b8:0:2519::112]) by forward7j.cmail.yandex.net (Yandex) with ESMTP id D5E7021D8E; Fri, 31 Mar 2017 19:36:44 +0300 (MSK) Received: from web56g.yandex.ru (web56g.yandex.ru [95.108.252.226]) by mxback9m.mail.yandex.net (nwsmtp/Yandex) with ESMTP id pCKnQduOBf-ai5W5Fjn; Fri, 31 Mar 2017 19:36:44 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail; t=1490978204; bh=znDVmpm+8LCMsG7/TN7qsSxtQdR9P7k3cLodozQH1Ko=; h=From:To:In-Reply-To:References:Subject:Message-Id:Date; b=tgI/AExxk0QtlMxV1ZNLfKk5VQMaxSCLAtmt8Qt4hmdXISpJb82N8yUAfR1JZTWFF HxKarmxa69yTnMCCWsxoBJKqsR+meSv8Eklt/cCvltgVTEATSZKriTnj8ktlcEv+fY hBbaeL//ks4dDIrXnPE+6bNvYtJJibrnkDyMhb0o= Authentication-Results: mxback9m.mail.yandex.net; dkim=pass header.i=@reddoc.net Received: by web56g.yandex.ru with HTTP; Fri, 31 Mar 2017 19:36:44 +0300 From: Samed YILDIRIM To: Lazaro Garcia , "pgsql-admin@postgresql.org" In-Reply-To: <001f01d2aa2d$1f9f27a0$5edd76e0$@gmail.com> References: <001f01d2aa2d$1f9f27a0$5edd76e0$@gmail.com> Subject: Re: Help with bad performance with synchronous commit MIME-Version: 1.0 Message-Id: <6346761490978204@web56g.yandex.ru> X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Fri, 31 Mar 2017 19:36:44 +0300 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 X-Pg-Spam-Score: -0.9 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org SGkgTGF6YXJvLDxkaXY+PGJyIC8+PC9kaXY+PGRpdj5QbGVhc2UgaW5pdGlhbGl6ZSB5b3VyIHRl c3QgZGF0YWJhc2Ugd2l0aCBzY2FsZSBmYWN0b3IgNTAgYnkgdXNpbmcgcGdiZW5jaCB0aGFuIHBl cmZvcm0gdGVzdCBhZ2FpbiBhbmQgc2hhcmUgcmVzdWx0cyB0byB1cz88L2Rpdj48ZGl2PjxiciAv PjwvZGl2PjxkaXY+QmVzdCByZWdhcmRzLjxiciAvPjxiciAvPjE3OjQ1LCAzMSBNYXJ0IDIwMTcs IExhemFybyBHYXJjaWEgJmx0O2xhemFybzM0ODdAZ21haWwuY29tJmd0Ozo8YnIgLz48YmxvY2tx dW90ZT48ZGl2IGxhbmc9IkVTIiBsaW5rPSIjMDU2M0MxIiB2bGluaz0iIzk1NEY3MiI+PGRpdj48 cD5IZWxsbyBldmVyeW9uZTwvcD48cD7CoDwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+SSB3aXRl IGJlY2F1c2UgSSBoYXZlIGEgZ3JlYXQgcHJvYmxlbSBhbmQgSSBoYXZlIG5vIGlkZWEgaG93IHJl c29sdmUgdGhpczo8L3NwYW4+PC9wPjxwPsKgPC9wPjxwPjxzcGFuIGxhbmc9IkVOLVVTIj5UaGlz IGlzIHRoZSBzaXR1YXRpb246PC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+wqA8L3Nw YW4+PC9wPjxwPjxzcGFuIGxhbmc9IkVOLVVTIj5JIGhhdmUgaW5zdGFsbGVkIGEgcG9zdGdyZXNx bCBzZXJ2ZXIgOS42LjIgb24gVWJ1bnR1IHNlcnZlciAxNi4wNC4yIExUUyB3aXRoIHRoaXMgc3Bl Y2lmaWNhdGlvbnM6PC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+wqA8L3NwYW4+PC9w PjxwPjEyIGNvcmVzIHkgMzAgR0IgZGUgUkFNLjwvcD48cD7CoDwvcD48cD48c3BhbiBsYW5nPSJF Ti1VUyI+SSBoYXZlIGNyZWF0ZWQgYSBkYXRhYmFzZSB3aXRoIHBnYmVuY2ggZm9yIHRlc3Rpbmcg YW5kIHRoZSBwZXJmb3JtYW5jZSBhcmUgdmVyeSBiYWQgd2l0aCDCoHN5bmNocm9ub3VzIGNvbW1p dC4gVGhlc2UgYXJlIHRoZSByZXN1bHRzOjwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4tVVMi PsKgPC9zcGFuPjwvcD48cD5zY2FsaW5nIGZhY3RvcjogMTwvcD48cD48c3BhbiBsYW5nPSJFTi1V UyI+cXVlcnkgbW9kZTogc2ltcGxlPC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+bnVt YmVyIG9mIGNsaWVudHM6IDUwPC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+bnVtYmVy IG9mIHRocmVhZHM6IDEyPC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+ZHVyYXRpb246 IDMwIHM8L3NwYW4+PC9wPjxwPjxzcGFuIGxhbmc9IkVOLVVTIj5udW1iZXIgb2YgdHJhbnNhY3Rp b25zIGFjdHVhbGx5IHByb2Nlc3NlZDogMjc3Mzwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4t VVMiPmxhdGVuY3kgYXZlcmFnZSA9IDU0NC4zMzYgbXM8L3NwYW4+PC9wPjxwPjxzcGFuIGxhbmc9 IkVOLVVTIj5sYXRlbmN5IHN0ZGRldiA9IDYxNy45NDEgbXM8L3NwYW4+PC9wPjxwPjxzcGFuIGxh bmc9IkVOLVVTIj50cHMgPSA5MS4xODA5MjcgKGluY2x1ZGluZyBjb25uZWN0aW9ucyBlc3RhYmxp c2hpbmcpPC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+dHBzID0gOTEuMTk0MDgwIChl eGNsdWRpbmcgY29ubmVjdGlvbnMgZXN0YWJsaXNoaW5nKTwvc3Bhbj48L3A+PHA+PHNwYW4gbGFu Zz0iRU4tVVMiPsKgPC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTiI+QnkgYW5hbHl6aW5nIHRo ZSBwb3N0Z3JlcyBsb2cgd2l0aCBwZ2JhZGdlciBJIGNvdWxkIHNlZSB0aGF0IHRoZSB1cGRhdGVz IHRha2UgYSBsb25nIHRpbWUgZm9yIGEgdGFibGUgd2l0aCAxMCB0dXBsZXMgb25seS4gVGhlbiBJ IHJhbiBhIGV4cGxhaW4gYW5hbHl6ZSBhbmQgdGhlIGV4cGxhaW4gcmVzdWx0cyBjb250cmFkaWN0 IHdoYXQgdGhlIHRlc3QgdGhyb3dzOjwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4tVVMiPsKg PC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+VXBkYXRlIG9uIHBnYmVuY2hfdGVsbGVy c8KgIChjb3N0PTQuMTQuLjguMTYgcm93cz0xIHdpZHRoPTM1OCkgKGFjdHVhbCB0aW1lPTAuMDIx Li4wLjAyMSByb3dzPTAgbG9vcHM9MSk8L3NwYW4+PC9wPjxwPjxzcGFuIGxhbmc9IkVOLVVTIj7C oMKgIC0mZ3Q7wqAgQml0bWFwIEhlYXAgU2NhbiBvbiBwZ2JlbmNoX3RlbGxlcnPCoCAoY29zdD00 LjE0Li44LjE2IHJvd3M9MSB3aWR0aD0zNTgpIChhY3R1YWwgdGltZT0wLjAxMC4uMC4wMTAgcm93 cz0xIGxvb3BzPTEpPC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+wqDCoCDCoMKgwqDC oMKgwqBSZWNoZWNrIENvbmQ6ICh0aWQgPSA1KTwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4t VVMiPsKgwqDCoMKgwqDCoMKgwqAgSGVhcCBCbG9ja3M6IGV4YWN0PTE8L3NwYW4+PC9wPjxwPjxz cGFuIGxhbmc9IkVOLVVTIj7CoMKgwqDCoMKgwqDCoMKgIC0mZ3Q7wqAgQml0bWFwIEluZGV4IFNj YW4gb24gcGdiZW5jaF90ZWxsZXJzX3BrZXnCoCAoY29zdD0wLjAwLi40LjE0IHJvd3M9MSB3aWR0 aD0wKSAoYWN0dWFsIHRpbWU9MC4wMDUuLjAuMDA1IHJvd3M9MSBsb29wcz0xKTwvc3Bhbj48L3A+ PHA+PHNwYW4gbGFuZz0iRU4tVVMiPsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKgwqAgSW5kZXgg Q29uZDogKHRpZCA9IDUpPC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+UGxhbm5pbmcg dGltZTogMC4wNTIgbXM8L3NwYW4+PC9wPjxwPkV4ZWN1dGlvbiB0aW1lOiAwLjA0MyBtczwvcD48 cD7CoDwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+SSBoYXZlIHJ1bm5lZCB0aGUgc2FtZSB0ZXN0 IGluIG90aGVyIG1hY2hpbmVzIHdpdGggbGVzcyBSQU0gYW5kIENQVSBhbmQgdGhlIHJlc3VsdHMg YXJlIGFsd2F5cyBiZXR0ZXIgdGhhbiB0aGlzOjwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4t VVMiPsKgPC9zcGFuPjwvcD48cD48c3BhbiBsYW5nPSJFTi1VUyI+QW55IGhlbHAgdG8gaWRlbnRp ZnkgdGhlIHByb2JsZW0gY291bGQgYmUgdmVyeSBhcHByZWNpYXRlZC48L3NwYW4+PC9wPjxwPjxz cGFuIGxhbmc9IkVOLVVTIj7CoDwvc3Bhbj48L3A+PHA+PHNwYW4gbGFuZz0iRU4tVVMiPlJlZ2Fy ZHM8L3NwYW4+PC9wPjwvZGl2PjwvZGl2PjwvYmxvY2txdW90ZT48L2Rpdj4NCg==