Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bKVqs-0007fu-GD for pgsql-performance@arkaria.postgresql.org; Tue, 05 Jul 2016 19:17:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bKVqr-0004DK-TX for pgsql-performance@arkaria.postgresql.org; Tue, 05 Jul 2016 19:17:45 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bKVqr-0004D8-7X for pgsql-performance@postgresql.org; Tue, 05 Jul 2016 19:17:45 +0000 Received: from smtp-o-1.desy.de ([2001:638:700:1038::1:9a]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bKVqj-00057M-TQ for pgsql-performance@postgresql.org; Tue, 05 Jul 2016 19:17:43 +0000 X-Clacks-Overhead: GNU Terry Pratchett Received: from smtp-map-1.desy.de (smtp-map-1.desy.de [131.169.56.66]) by smtp-o-1.desy.de (DESY-O-1) with ESMTP id C9D6C280A96 for ; Tue, 5 Jul 2016 21:17:33 +0200 (CEST) Received: from ZITSWEEP4.win.desy.de (zitsweep4.win.desy.de [131.169.97.98]) by smtp-map-1.desy.de (DESY_MAP_1) with ESMTP id B41D713E9E for ; Tue, 5 Jul 2016 21:17:33 +0200 (MEST) Received: from smtp-intra-3.desy.de (lb-40-26.desy.de) by ZITSWEEP4.win.desy.de (Clearswift SMTPRS 5.5.0) with ESMTP id ; Tue, 5 Jul 2016 21:17:33 +0200 Received: from z-mbx-2.desy.de (z-mbx-2.desy.de [131.169.55.140]) by smtp-intra-3.desy.de (DESY-INTRA-3) with ESMTP id 56329120F; Tue, 5 Jul 2016 21:17:33 +0200 (MEST) Date: Tue, 5 Jul 2016 21:17:33 +0200 (CEST) Subject: Re: Tuning guidelines for server with 256GB of RAM and SSDs? Message-ID: <89036cd7-e798-4e2a-a6bd-ab98641a452a@email.android.com> X-Android-Message-ID: <89036cd7-e798-4e2a-a6bd-ab98641a452a@email.android.com> From: "Mkrtchyan, Tigran" To: Kaixi Luo Cc: pgsql-performance@postgresql.org Importance: Normal X-Priority: 3 X-MSMail-Priority: Normal MIME-Version: 1.0 Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 X-Mailer: Zimbra 8.6.0_GA_1191 (MobileSync - Android-Mail/6.5-1.123769152.release) Thread-Topic: Tuning guidelines for server with 256GB of RAM and SSDs? Thread-Index: Blbi1RQvDJvroBoO9zHQsUbQVb5+2A== X-Pg-Spam-Score: -1.5 (-) 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 PHAgZGlyPSJsdHIiPkhpLCA8L3A+CjxwIGRpcj0ibHRyIj5XZSBoYWQgYSBzaW1pbGFyIHNpdHVh dGlvbiBhbmQgdGhlIGJlc3QgcGVyZm9ybWFuY2Ugd2FzIHdpdGggNjRNQiBiYWNrZ3JvdW5kX2J5 dGVzIGFuZCA1MTIgTUIgZGlydHlfYnl0ZXMuPC9wPgo8cCBkaXI9Imx0ciI+VGlncmFuLjxicj4K PC9wPgo8ZGl2IGNsYXNzPSJnbWFpbF9xdW90ZSI+T24gSnVsIDUsIDIwMTYgMTY6NTEsIEthaXhp IEx1byAmbHQ7a2FpeGlsdW9AZ21haWwuY29tJmd0OyB3cm90ZTo8YnIgdHlwZT0nYXR0cmlidXRp b24nPjxibG9ja3F1b3RlIGNsYXNzPSJxdW90ZSIgc3R5bGU9Im1hcmdpbjowIDAgMCAuOGV4O2Jv cmRlci1sZWZ0OjFweCAjY2NjIHNvbGlkO3BhZGRpbmctbGVmdDoxZXgiPjxkaXYgZGlyPSJsdHIi PkhlbGxvLDxkaXY+PGJyIC8+PC9kaXY+PGRpdj5JJiMzOTt2ZSBiZWVuIHJlYWRpbmcgTXIuIEdy ZWcgU21pdGgmIzM5O3MgJiMzNDtQb3N0Z3JlcyA5LjAgLSBIaWdoIFBlcmZvcm1hbmNlJiMzNDsg Ym9vayBhbmQgSSBoYXZlIHNvbWUgcXVlc3Rpb25zIHJlZ2FyZGluZyB0aGUgZ3VpZGVsaW5lcyBJ IGZvdW5kIGluIHRoZSBib29rLCBiZWNhdXNlIEkgc3VzcGVjdCBzb21lIG9mIHRoZW0gY2FuJiMz OTt0IGJlIGZvbGxvd2VkIGJsaW5kbHkgdG8gdGhlIGxldHRlciBvbiBhIHNlcnZlciB3aXRoIGxv dHMgb2YgUkFNIGFuZCBTU0RzLjwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+PGRpdj5IZXJlIGFyZSBt eSBzZXJ2ZXIgc3BlY3M6PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PjxkaXY+SW50ZWwgWGVv biBFNS0xNjUwIHYzwqA8c3BhbiBzdHlsZT0ibGluZS1oZWlnaHQ6MS41Ij5IZXhhLUNvcmUgSGFz d2VsbMKgPC9zcGFuPjwvZGl2PjwvZGl2PjxkaXY+MjU2R0IgRERSNCBFQ0MgUkFNPC9kaXY+PGRp dj5CYXR0ZXJ5IGJhY2tlZCBoYXJkd2FyZSBSQUlEIHdpdGggNTEyTUIgb2YgV3JpdGVCYWNrIGNh Y2hlIChMU0kgTWVnYVJBSUQgU0FTIDkyNjAtNGkpPC9kaXY+PGRpdj5SQUlEMSAtIDJ4NDgwR0Ig U2Ftc3VuZyBTU0Qgd2l0aCBwb3dlciBsb3NzIHByb3RlY3Rpb24gKHdpbGwgYmUgdXNlZCB0byBz dG9yZSB0aGUgUG9zdGdyZVNRTCBkYXRhYmFzZSk8L2Rpdj48ZGl2PlJBSUQxIC0gMngyNDBHQiBD cnVjaWFsIFNTRCB3aXRoIHBvd2VyIGxvc3MgcHJvdGVjdGlvbi4gKHdpbGwgYmUgdXNlZCB0byBz dG9yZSBQb3N0Z3JlU1FMIHRyYW5zYWN0aW9ucyBsb2dzKTwvZGl2PjxkaXY+PGJyIC8+PC9kaXY+ PGRpdj5GaXJzdCBvZiBhbGwsIHRoZSBib29rIHN1Z2dlc3RzIHRoYXQgSSBzaG91bGQgZW5hYmxl IHRoZSBXcml0ZUJhY2sgY2FjaGUgb2YgdGhlIEhXUkFJRCBhbmQgZGlzYWJsZSB0aGUgZGlzayBj YWNoZSB0byBpbmNyZWFzZSBwZXJmb3JtYW5jZSBhbmQgZW5zdXJlIGRhdGEgc2FmZXR5LiBJcyBp dCBzdGlsbCBhZHZpc2FibGUgdG8gZG8gdGhpcyBvbiBTU0RzLCBzcGVjaWZpY2FsbHkgdGhlIHN0 ZXAgb2YgZGlzYWJsaW5nIHRoZSBkaXNrIGNhY2hlPyBXb3VsZG4mIzM5O3QgdGhhdCBpbmNyZWFz ZSB0aGUgd2VhciByYXRlIG9mIHRoZSBTU0Q/PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PlNl Y29uZGx5LCB0aGUgYm9vayBzdWdnZXN0cyB0aGF0IHdlIGluY3JlYXNlIHRoZSBkZXZpY2UgcmVh ZGFoZWFkIGZyb20gMjU2IHRvIDQwOTYuIEFzIGZhciBhcyBJIHVuZGVyc3RhbmQsIHRoaXMgd2Fz IGRvbmUgaW4gb3JkZXIgdG8gcmVkdWNlIHRoZSBudW1iZXIgb2Ygc2Vla3Mgb24gYSByb3RhdGlu ZyBoYXJkIGRyaXZlLCBzbyBhZ2FpbiwgaXMgdGhpcyBzdGlsbCBhcHBsaWNhYmxlIHRvIFNTRHM/ PC9kaXY+PGRpdj48YnIgLz48L2Rpdj48ZGl2PlRoZSBvdGhlciB0dW5hYmxlIEkmIzM5O3ZlIGJl ZW4gbG9va2luZyBpbnRvIGlzIHZtLmRpcnR5X3JhdGlvIGFuZCB2bS5kaXJ0eV9iYWNrZ3JvdW5k X3JhdGlvLiBJIHJlY2tvbiB0aGF0IHRoZSBib29rJiMzOTtzIHJlY29tbWVuZGF0aW9uIHRvIGxv d2VyIHZtLmRpcnR5X2JhY2tncm91bmRfcmF0aW8gdG8gNSBhbmQgdm0uZGlydHlfcmF0aW8gdG8g MTAgaXMgbm90IGVub3VnaCBmb3IgYSBzZXJ2ZXIgd2l0aCBzdWNoIGJpZyBhbW91bnQgb2YgUkFN LiBIb3cgbXVjaCBsb3dlciBzaG91bGQgSSBzZXQgdGhlc2UgdmFsdWVzLCBnaXZlbiB0aGF0IG15 IFJBSUQmIzM5O3MgV3JpdGVCYWNrIGNhY2hlIHNpemUgaXMgNTEyTUI/PC9kaXY+PGRpdj48YnIg Lz48L2Rpdj48ZGl2PlRoYW5rIHlvdSB2ZXJ5IG11Y2guPC9kaXY+PGRpdj48YnIgLz48L2Rpdj48 ZGl2PkthaXhpIEx1bzwvZGl2PjwvZGl2Pg0KPC9ibG9ja3F1b3RlPjwvZGl2Pg==