Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cVgce-00030q-P9 for pgsql-performance@arkaria.postgresql.org; Mon, 23 Jan 2017 15:33:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cVgce-0002fk-Bw for pgsql-performance@arkaria.postgresql.org; Mon, 23 Jan 2017 15:33:32 +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 1cVgay-0000iy-GY for pgsql-performance@postgresql.org; Mon, 23 Jan 2017 15:31:48 +0000 Received: from mail-by2nam01on0083.outbound.protection.outlook.com ([104.47.34.83] helo=NAM01-BY2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cVgau-0000s1-O6 for pgsql-performance@postgresql.org; Mon, 23 Jan 2017 15:31:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=nasdBgiT68kPm/iSMFg+ymCEq1AjtgUR2QaxI08oIZw=; b=d0qgvYgdgx0svsjWSc36H98oizL5FqSwoTg9wGFjM/MA8unkunxrG4eNNv5+0+INbrqSXPTZaE9DAiaILg+C+KXcSXdf5gTE700P8bD6mm109o065YDjZp5L61L+uzQv6uO6nb1HUrfd3UnSDZT9OzmwvYOROC047mE8HUymbWY= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.attlocal.net (2602:306:ce8b:3460:fc78:abce:71e8:6436) by CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.860.13; Mon, 23 Jan 2017 15:31:39 +0000 Subject: Re: Backup taking long time !!! To: Stephen Frost References: <23dc5b1ea9604ec3afdaabdd15491085@cyient.com> <20170120122224.GF18360@tamriel.snowman.net> <20170120134054.GH18360@tamriel.snowman.net> <7696A57C-C871-4A45-9141-FFD5F75CCB65@simply.name> <20170120150646.GP18360@tamriel.snowman.net> <68f87a97-15c2-5e4e-5730-77f9af2ca165@BlueTreble.com> <20170123152722.GX18360@tamriel.snowman.net> CC: Vladimir Borodin , Pavel Stehule , Dinesh Chandra 12108 , Madusudanan.B.N , "pgsql-performance@postgresql.org" , David Steele From: Jim Nasby Message-ID: <1ddb6452-b5c0-9ee7-7f76-cdca5563a60b@BlueTreble.com> Date: Mon, 23 Jan 2017 09:31:29 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.6.0 MIME-Version: 1.0 In-Reply-To: <20170123152722.GX18360@tamriel.snowman.net> Content-Type: text/plain; charset="windows-1252"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:fc78:abce:71e8:6436] X-ClientProxiedBy: DM5PR03CA0022.namprd03.prod.outlook.com (10.175.104.32) To CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) X-MS-Office365-Filtering-Correlation-Id: e7383827-0ee3-4a5f-5956-08d443a4eebd X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:CY4PR11MB1637; X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;3:NJQvL7bJUhZhUg+kA38agsYs6TSMf6LHf0BsDbFxHlJ1fcUR/nIPB0m/NIOwhGgNE8JmVfzp0Z5uIdglqFELeJ66oPPumdISBSONWQEPZgDhnrrDbWV5Z0TEIlPsCrFr3gW5MZK9myxV0TzMzITQbPuUPIpbdGqHDxaQ2teFe9CRw4RdpgW/OzsakPJvw/s0CD3T6h64GTkJj8vl4OLEG18yAz/ijKUXrbSnMTCfMA3xJRrVaX5wtxmaRnoUjAGTR3EjX82ucXRpx5vYFDWX+w== X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;25:9VgshZ6fqbFP8/YfMnovKiqnnXK/x+SKJAoAxfwwbDj/DPIdx2QhLpaBWplu0c9pXeIwmXcqojDrp+kQnfG3rej4N2/GOGoK5fKloSmhyFtLQuGVtpuXpzm5PbzZ6PDV7pNz/J+lTu1Sarw74TCVp0dDYRI+vPqk0xLol7AypuuLsuYYFDkgn9dWdU4ZtsNYGbz4PHKoYRr5X9DpFvtSpj5QNDPrvAAo3QjDJYHxPpRZKZXEtbRM1tkeiHsUVUt2zkd1Emo6rOGS6eiUTiN2vjJOlhl9arWmIgLNiWhXn04irzKGsmDDVHOM2M0nvgrUfy5Fnaom/58Dfo3t+49yhLIk6ySVFJVUNnCYkGsstxFbir94/xDYPxqOc/1nB16LPF/sjMsznvO+DAdDtFc8jbm6fyOA/AWeXVab7stn+F7jOF8vefxg5FSM1Vxu8bmU+FQiHrCtT06+cTevBnt/1r1tTpZeC7Bj6tD1ZpaDoIBInkiGqZPyLbtw8j5KYfMK3JVtza8Nj+sFotclegAjnJS5jKk2sl8LKI6r8AP7UT8//rf0Si1JzofbB2Vp+l1hYgNwAXi8WehTUlOQ+FOW2KRzmqZGmIciZo9qDamQwFgjZxp0QF5RaY4TLwQQzQ+/uz21xVTnh4/hlUhFZpiJwPeoVjivGuLSSIZqCe2dr5N4gdH6qZvhBera2/p08/Ch/CfIlV+Zs/Evb6wg1jDAM85p9k+NEaqNOegHuf1++MArojui7Ip3y4FY3Q+66yjofsce4/9VJb5Fh/dMwtyQ8fGmBAY1dKTCiXmlKK59AmpZdYaYF48EA7DjkuOp0CeNyuSHzuXdlCOdH3cCcMdPGQ== X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;31:1puwsBqD0TcmsM7FYt/haF/Eb2HN4vLlivoPCoXRDWeEUeEFvSNrfiDFjk8OGvIbOsfRpoLKyFOOvT+p1jq7PrJDIHZua0LAYdcq4PGG/4LV3CFKTzKqpXoh75IBCwf2nagNiMNpZj7/bqMBV6Ml9uMPm/tdECS2ObF7YifKTUlWmiD1SV8JE6eF2yTfji2fzeEPxqlD+IRA5WeFEQVu+6s6DUlZYDYGotd/XJIJHYCUS4t7igSyVxC/god1+Sttg4g1Rlu2IYRgBR1NpCLmIA==;4:2lJs6qx7PrruF4JZbtw3qA+4VgyZiXlZKaqkslaPPDuPBY2/RjPv9E7pR+VvESxFNCBwdDUO3S2ok7nhhgbESJ9CXtc0odlQAqddQof70kVGl1xNQ0BPf2EXxlCRNEc3J062P0pJdHSvAyqeDUrkzaY720qkSvtFoH9gx4jTyuf5GyoWe0AzM0Bzfe0MtU3T0K0K0qHcW/W3o+HuhPeCa8sG0R5HBvc7VJVchP2vARaXawqST7nxVoXyuFzh2HlDjygR7DpcKQ+7BMS20gX+KUzW6wtYmPvr4YWxT8+47LI087hmhrr13coz7hMiFejSuiype5dFxLaRHASDBvYYbryApyn2hqy/iarTyQVGawoHVRmDFQjn+9QXlKhG5MVt7rucRkDsvmPCiBozkoOmoeVF6iX58NrsK5QYNLn+VCoDu9L7szmbQ8LMG0Mwf9nchZxdhCVcPk5YnaSIvoCcOinH5bvgNMiXQfbHmO2GQJBcSDbdi1WKKKmiLf1iGH1gE6wPtufyPVggaWf2VXVES3OeemtnXCRKI0rkgjvudxY1QloGzM+WgGbPM+jxNe2ZG9nPMGhoWHKmO1P6I+5vtrgg3GegIKSlTx0E9A2hDCHKklbnaXILJbCwVCWZwHAU X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040375)(601004)(2401047)(5005006)(8121501046)(3002001)(10201501046)(6041248)(20161123562025)(20161123555025)(20161123564025)(20161123560025)(2016111802025)(6072148)(6043046);SRVR:CY4PR11MB1637;BCL:0;PCL:0;RULEID:;SRVR:CY4PR11MB1637; X-Forefront-PRVS: 0196A226D1 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(39410400002)(39450400003)(39830400002)(377454003)(24454002)(199003)(189002)(6916009)(54356999)(23746002)(76176999)(38730400001)(50986999)(101416001)(230700001)(6666003)(6116002)(47776003)(2906002)(31696002)(86362001)(229853002)(4326007)(223973002)(39060400001)(7736002)(92566002)(33646002)(110136003)(93886004)(2950100002)(6486002)(189998001)(65956001)(65806001)(54906002)(6512007)(6306002)(6506006)(25786008)(68736007)(50466002)(5660300001)(65826007)(4001350100001)(16601075003)(31686004)(36756003)(42186005)(81166006)(81156014)(8676002)(97736004)(53936002)(105586002)(69596002)(106356001)(83506001)(64126003)(305945005)(53416004)(225543005)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:CY4PR11MB1637;H:decina.attlocal.net;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: =?Windows-1252?Q?1;CY4PR11MB1637;23:RmtK5WWwxo292x8YSQQuLkeauNG89pI8mxnKh?= =?Windows-1252?Q?AivzmEncJGwvtEpEFjLopv7w1zFc3JHH5Vm5cR/Wl5F+duQ14DTvqOGs?= =?Windows-1252?Q?WjUTGQoTtd9qIGzcc07QjBsJ9wS3GMgzF2gIhQhjm4Ehp+/v4ppOkGAI?= =?Windows-1252?Q?JWcKL3WdnZtaygDXJyjqxCj2ybGNG+SkFg21D/dkV1fwaMl980k0HaDp?= =?Windows-1252?Q?HbfYZ2IbVIlF8aSicExx1fLf9T3cem2RdnGr78VbO9x0xz8NigBnrXf2?= =?Windows-1252?Q?lahiAAOvYpIMrqtXJWwfmRC0cDLqGovCzWWQmk6QBIO3c294mR3fexn2?= =?Windows-1252?Q?8om78ro3QMMOC1ets9m3behCwTg4fERPF8xXKgJjcz9mrMk1zKCQqyeH?= =?Windows-1252?Q?c3koxdhOrnGlKqiR7fpFjExNeakafhpMvoGamZlcUnhjkuaQo2bF/JAa?= =?Windows-1252?Q?kpztu0NLUlNnej91tcSiw8KjSczoAScE3G+wDyJPWOHstUrfAhSaeqlx?= =?Windows-1252?Q?NSEvqYyjUydeFQA0e1lSiTTCjL1JL0Tn3Mzn4SNbkQXQbkJHLWXqv8fP?= =?Windows-1252?Q?w6TI1pqfG7N8KDs30EM2UiayRucIp4pNHdpV5vJ3w49vCap9UCFi/X18?= =?Windows-1252?Q?QWGjPlcZHh3BHh2H0o8PQcdw4tkHoFAUPeZh3ZWTPiqxWbKOjbrNYPp1?= =?Windows-1252?Q?pkDtupLU8qFt1w2TVNdek5DcmSJibVrpeyn4pSk5XSxvvyTrErKo+3ox?= =?Windows-1252?Q?+SceIAudaKydPIP/bUygyqlqWzDOVvaaI2Zp4D3UAxr5dkymDS4VvOUJ?= =?Windows-1252?Q?G/5m2c3xsPO7eQWcXyQtyKaEowc6iQkYDojcwCu3XxCLP4n7sWGdFibp?= =?Windows-1252?Q?CZlr7ED3vsVCxuRGcM48FSB/2PgWuqim5QSAa8DlNnzP0eUAcbbscKIc?= =?Windows-1252?Q?1TVPod+/XcPtCQO5+aYkpM5J/m8RlPYS0O2lOEDAaD9+tm7/zjG6C1oF?= =?Windows-1252?Q?VGvnw0F3zWSiCRB404p4oaJEsfbkSI4XjjkNcV+vSpl7N9r7iimPndAO?= =?Windows-1252?Q?xNmEdHyudJBayCfLy3Kr0gwck+AOxHVWh8+GWYBgvMez41y9wXL7ESPd?= =?Windows-1252?Q?xpQCv9Z4sw0TpnxlOzpx0y1Mrv86PMXny7BhUGjQ5Mn/ejs0xfJcQB/O?= =?Windows-1252?Q?97iW0Bo0BlxCnJZ59tMf8O1v8vtULHiMrj4cKBTWb4vyjOIHml1H9Rxw?= =?Windows-1252?Q?PiOucdyrCNzm/FeJ8iW6e9ONyV4f5XPSMuMDJ/EGqr45YL7KQZYtkWvV?= =?Windows-1252?Q?P+nObPZr9XhdwiolAhu2ia6bGqCug/elWu6k83pFtuVtmPZU7QUgltYl?= =?Windows-1252?Q?nZa/UZN5O2AfXiw+Oy16F0xnANY1S4Rz0GoGza0xktJb63UZ86jkzGN5?= =?Windows-1252?Q?gBpR7KE5ypxEXLa/nGy1ugA6UK+PVHm5uOwek4IYWDq2eCE/2o5E/y9B?= =?Windows-1252?Q?ObUUtTHUj03i9eZRG9q8UtO3TNITJbZqUCPiJzb4wssV0QoNGz/SIoh/?= =?Windows-1252?Q?mVYgzpx8sZfCSWESs2uRVXDFTI3eJETkv4pl5+RIoDhpeCFd+yPhR2KU?= =?Windows-1252?Q?zCFM0T9ATyZarsYTfODyaUDiqGBDpKCWsYNBCSFFKxADLBh6KYjuxOWw?= =?Windows-1252?Q?DOSKbr2yDm/s2f6paeWfKX59q3meBk=3D?= X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;6:RRDFEsX1AnFSpP6uEBeEWnhs531UIBamew6YajMAG3+aRSPcif+jZNEYWYI0rhUc4qe8kp71E3vIoKAsa4o5jKOnPsPPx3Gba3YOWJPv7Y9tgB8K6JXVLAenBS8XKNyMcOmV0j1ggRs10EH94Aj4M8BAO2666kEBYRCiPeVe3WYz+14w9M385l14NjMAlgGRs0ENVOh0AYQYwJhhFFUAUd9tO5lFHihB0duh9K+EgTB0cQD/Z9U3VTKopJYTx63Mftx+8CyNBTHkjR5JYgBHZtxAXv+FnpXbdcPynOznTAiohF2FvzMGDYPfd3QY7hiLO5blLW8ywU4rvIlwvH9u2tHZcw5C/aDR6FQhOG1KBRSBSJcdWu4RdWLWymCdv702gkr5a69w2H6DMo3dIj2rYNJZ+XFzhNSMnao2zCSYmZcgpHZ87n09IdhLYjP6YcXM;5:gQcVJd+0UxdVW/MKKqyNehqvofKKgEfnKKhC7ttqDEpI/4Qt7hlfIQK+UBCowYWJ2rYaLiT+xzH+Qc4J6mKFL3sPga2pkmTXjJ7B6S8MVQPQozXLVaWdRGxwEQNqvykObnNp+0t5GYWL0mR6KS3yag==;24:MvXB+GH9ZzhwMU+eLjJ8E0qn5prUJ3jFDighs7/gnK+UfL7RHhpD6iTqHr/gT6xcB9dOkf9xtm/ORiTiyKw9ROt6dw1KzW/qxQ0ruHCpcCE= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;7:ndnLsYAYNUU99awQ1yvWYajF1SuDiNbdU03uecwhfbFsrFPW3K5g3QXXBZUQYO7i/ZP2FHpBhCJm6mSk8RKoy1bPjHCin4fdTKLiOt7KMJYWbMsQ1piFrseI2Yf7fkyoyPDZjPt5emWQKmxA3gn70YiEO4VL5jaz7RkzEJ1P204sKxByoAQwZ2YiWDUq8HlaPh+Kb+Q9gnPVJ9Wn5BGgKl6ohd1PmxyF07C8UdQaLT49fhjnHvARRkGnePuHSWjViAWjf+uOp7jz3rRn3CMDXbuywYH8LmW4ZMGGmx2bqWBIoVVrgtNgd1w/pB57Hrz8mCs+EqR/EmR2fgaxWcDsDUBWlI2ItQ1RFiC1fSbxYifzOOo14mU09Dwxx2kijWA25rEkYPDzGbA5FajHFeaoRjYqAELP2cJukcZh8nD5b6SpblFrCtI30rBdQeTAX+98dcm6EwFFZ68BpdeViJTB/A== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 23 Jan 2017 15:31:39.9635 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY4PR11MB1637 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 1/23/17 9:27 AM, Stephen Frost wrote: > If you want my 2c on that, running with BLKSZ <> 8192 is playing with > fire, or at least running with scissors. I've never seen it myself, but I'm under the impression that it's not unheard of for OLAP environments. Given how sensitive PG is to IO latency a larger block size could theoretically mean a big performance improvement in some scenarios. -- 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 855-TREBLE2 (855-873-2532) -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance