Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cVgOU-0002FK-94 for pgsql-performance@arkaria.postgresql.org; Mon, 23 Jan 2017 15:18:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cVgOT-0001wW-OB for pgsql-performance@arkaria.postgresql.org; Mon, 23 Jan 2017 15:18:53 +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 1cVgMe-0008L6-G8 for pgsql-performance@postgresql.org; Mon, 23 Jan 2017 15:17:00 +0000 Received: from mail-dm3nam03on0070.outbound.protection.outlook.com ([104.47.41.70] helo=NAM03-DM3-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cVgMa-0001oY-68 for pgsql-performance@postgresql.org; Mon, 23 Jan 2017 15:16:59 +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=8b6EVbSY4Jqk1wcKnrQo+fXZ5+JAFf+GOFZSv8vbvqc=; b=GM53AuPywfxwWASVCfAx0U2hqtQa+QMHhLQnRejNMpuKfT7ysyFXlQes7MXucDfJg9pN4/va+Z06h5R9FdILQ4W/upr78/7R3Db7lGJ0QwiEzL3tdzmXGIWswizIjEmOaVHFG5HUExRSwWPinoXAV8gpejN3P4JIIqpumxqAjj0= 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:16:49 +0000 Subject: Re: Backup taking long time !!! To: Stephen Frost , Vladimir Borodin References: <0fb0c8c3f69340a3a7d70b1c39fa2b2c@cyient.com> <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> CC: Pavel Stehule , Dinesh Chandra 12108 , Madusudanan.B.N , "pgsql-performance@postgresql.org" , David Steele From: Jim Nasby Message-ID: <68f87a97-15c2-5e4e-5730-77f9af2ca165@BlueTreble.com> Date: Mon, 23 Jan 2017 09:16:38 -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: <20170120150646.GP18360@tamriel.snowman.net> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [2602:306:ce8b:3460:fc78:abce:71e8:6436] X-ClientProxiedBy: MWHPR20CA0021.namprd20.prod.outlook.com (10.171.151.159) To CY4PR11MB1637.namprd11.prod.outlook.com (10.172.71.13) X-MS-Office365-Filtering-Correlation-Id: 04ea0af6-2203-4dc8-9697-08d443a2dc78 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:CY4PR11MB1637; X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;3:vBd4QKW2B/rqiF74pf/3c5TPOGUwzgbwPHYvQyZP/5yGtST2Pg7fSSjPVMz3yhipcDzj0923Ac+y+jV3waF++5d26deSsM5rvWi/TieMFWQW7/xYEij3C8+FvpWSJ2DuRsKoXBd2pJh6jVxhsTBA51UskoDSXu8RiB1VhtJjNjLDQqVuzt2dALiSSCZxg0jF6jpTRQv9lPZUj5zS8wsopykGnyuMYEVmkCYKftlciigjwDA10vhM85XhnYQvLXnP5ziB7NKWq6D+zM8dxMgSJw==;25:tPmv2AUkNPw9NmBmprt1wPR60cotgJfJI/+IbDwSFCmocxLNoWCXcVV9B41or1o5PLx+o6ykwMWtbw8ymVLXiPssIcxTYUFA5+9vh8vNZFE0hM3z/le1hpNcK9fWWCr0ls7InLGG3cGHagYRMwDyUavk/GvmMHMaD35OTr8Ts8ac2QfvrPiVwHaf0fSCoK293sSbu0nVwUbP0X9fxUyn2lX7F+snOFC4Lk2APXVRNq0MVfxLk/90RtSAkafHUUTHsBSar4bi38k6mX2iFf3lm64/JLGtVvkrJrutMC9oZoICl+inmk/NZvFILtSCKheX29T+XEvx6CWIP1TX5EOoswt9+536nJJWxfRVf2YOPyJXOS3FgKMaThpqev+4DW73DAzt2zBdwVZor/oJJ47pK+C5RHqRV9NMmLRcvu+AoUJS+Hhcv2MzlSm5DwzJLemD X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;31:WEbkHeoTQa9saqurTt0Bn1J2Nji+zN8dqJkP2I5rfvM7h9mZKhdC2KaeE/0Qi9STYqrZsSL436974ct+wUlAFiAWyuyH9wu7McPGavvS8wHR1ycmVbL3FEsUeKGj6XgVK+vgKbIQMhqmtBkphI4ho5wX7RlFE5JAooDK7P8L89WmkRQr1Zqf2Y/Xnw8M/tpxeCiozcmr5LYJptHkgMdzI6nbQ5UMgOCbtC7qxdT1OmfPc2WsH4/YZKOWGJcDjb34uVzUQGdMttc65ppY4BVPoQ==;4:WAJmoWIZLbA5/QmdrXrARelka/0kTZ03NFbSffoajM7Dgr5FkAMP4o+CgduZFlsb7SL+er8WRDnknhr7yMPktic9bVSyME3BWVpI4mSVX2tpeay2f8xyVYbrIvSl3e8fUrj+jEE3zAcU9cp6Ma9pnH7D2TlDvz8CL/qQiR8ENGl/rawEZ49/boQdhfdvJPkxDT3qFQiaWNdCnR9FJ3CoBfBtC1FapwJmLH2lnnchb8/Baijo3H+0NARwTEs5Jwu2sqGgU8Wbus6us7B9+AmtvWINUzhCEXbO9LnuX/zcUMOFwLJfP3WfatYCRYoMDTrgjbVc0s6wmZ26SN0Ec81ngoCfr/Hz6Cn9iFKAHdyXqaJa3daETap6Bl5HwXh87VaDWSv8T+OW6bSa2Q0y9N6RIJTGb45RMdolllbvkS43UXlr4mJ3GMRMAJDyjOZZ7pG8ohYdtb5Z5sgasCowHa9YceITxkeu47Ii7KsZeYKNwU8bpcX3uCZ8hGpZfqsDO+qzWfWqSXaaNIH1XDPYh4dVmt6s53URQ4wq26FmJNvsZ9MPHUXFLQihrNqUqe/0/23tzwYrHHb2JBNbdaXXyBENaKfzzd+ltAPaaKXTTFnAQzGV1sLuaxwnWM8ySmsJSfH7 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)(39830400002)(39410400002)(39450400003)(24454002)(189002)(199003)(377454003)(5660300001)(50466002)(16601075003)(4001350100001)(65826007)(54906002)(6506006)(6512007)(6306002)(68736007)(25786008)(83506001)(106356001)(69596002)(64126003)(305945005)(53416004)(105586002)(8676002)(36756003)(31686004)(81166006)(81156014)(42186005)(5001770100001)(97736004)(53936002)(2906002)(47776003)(6116002)(86362001)(31696002)(54356999)(76176999)(6666003)(230700001)(38730400001)(101416001)(50986999)(33646002)(23676002)(93886004)(2950100002)(7736002)(92566002)(65956001)(65806001)(189998001)(6486002)(223973002)(39060400001)(4326007)(229853002)(225543005)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:CY4PR11MB1637;H:decina.attlocal.net;FPR:;SPF:None;PTR:InfoNoRecords;MX:1;A:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtDWTRQUjExTUIxNjM3OzIzOnlsbTZtNEhYMGR5VUY0Z0JOdU81QndPaG1q?= =?utf-8?B?TmlrZ1BJdmczdHRtNi9WL2tWdy8zREtmelM1clpsR0VlaXdTRUtMQ0JqaHI5?= =?utf-8?B?aVpvK3BoTDBIdUNIR2pLU01zQXUwNmVIUjhjcHZRdndUWjd3L3EzekJ6L0Rv?= =?utf-8?B?Z3cvMWFhdWhHeGlPSUp2NTJUSlBJVkRVc0Nhakp1UUtRMm1GaDR5REJIV1hU?= =?utf-8?B?WFVNaVFYSmhsQW1pcGtaSDJaaFhxUDBkWFYyRlhzVjNBZzhxQVR1UklmdVBO?= =?utf-8?B?eHBhdjdLWHNNc0NMMkN6bEUvTjlVZHIzcDF2b011bHlMVkVsZVdtZjN2YUNN?= =?utf-8?B?RWlOVFljbGNoVExCZWlmbzlNSHQ2b0V3QUFBTUlneTh5L2NkQStuWEVxT2VV?= =?utf-8?B?cm91S084OUFIK3hGNDAwVTZ4MmhFaldzQ202Z280MXVkZm55eUdMT2JYMWtG?= =?utf-8?B?T2FQOVFuYTRZK0VSUDlnOGFQRE5BODlSS2tJZzBzUVFobTRJNDBFcFViOUxX?= =?utf-8?B?V0xuN2dNNUJicXhoN1JaSS9hRlZxRm5qLytmN0M5T0dWVksyME9oVUdDUlM0?= =?utf-8?B?OE14Z3NNQmJDdVJ6SzhTY1BKRVhwMVZteHBDKzVVYzk1Q1pZYk15cXpvSUVl?= =?utf-8?B?bFAxMVN6cU52Q3dMRmp2bHZVWGo0M3dXVzh0a3VHMnpkRC9OWGJtWm5mdVdC?= =?utf-8?B?SVREUDR3V1Fob2pVZjZuaXhIeTFDWUpXWXQ2VTNPUEZwcTRIeXJyemlqUTlH?= =?utf-8?B?UHo3YVgva29EZjdkbW5CY0JoeEVmUVIzazhMNk5VZVdzYlFpZ2xGMTJPdGpE?= =?utf-8?B?U2g3a3pvR2FCN1N6cUNaSnRqNjJHbkhkaGFvUkRLTnpoK0tLYkZuZnkwOWUw?= =?utf-8?B?UE54c2lkYURXRXpDMFFXR1dnbnc2Qnk0OS9NczZxa0NRZ1hBU0tzNkt5d3JO?= =?utf-8?B?bFlYcS8vWFZ3SlNRTDVLUVRxdlI3NDVGS3J6K04rb0xZYktXT2F6Q3dwMi9x?= =?utf-8?B?bExTMU1JUGVjbm53VXlRRnpYSHNUdkJ3angxTVNITjJ6cVdhcW9EK1dqekdk?= =?utf-8?B?WWZYS204MkNzdTc5OWZGTmlLcFlnK1ZBc3NDVDRaZjhPQVQ4SVBoRUdlcnVE?= =?utf-8?B?WnVHbFRQQ0tIVG1RYnBvSmIrUlJPcklhZ2VJZE1YclZsZnQ3RG15NUVjcmlB?= =?utf-8?B?QzNVeHpIK1lzMkc0RUVDWklOeWNSTjM0M1dWbTQ4aDBxbjRoc3dvSlpZaExv?= =?utf-8?B?R1MzTnQ1ZHNpYlNadHZjUzdvc3dWdmNFbkpjeGVXVlFTNHBHdU1mS3VaeUFr?= =?utf-8?B?M2RvNDNGRFZmRXdYWGdXZWlacmFMWFd0M3dodmpKejd0aWwvLzdQY2Ztclk0?= =?utf-8?B?MjJvZmhVUy9oOHltQlJhYkVjbUQyNkUvdi9kSjJNT3J3anZZRUQ5bCtoekhP?= =?utf-8?B?VjJBOXFsOXBjekwyaHJuU2t5YmxORE9SNjhUa3pkS1RHTjhsZVJOTUFkSzF0?= =?utf-8?B?S0RuQ0FVc3F0bDgrZ055cTV2MzRkYllBT1M3b3RmYTVTMml3RUV1UVFtOVph?= =?utf-8?B?NDEybDNNaXcrckU5Y0NTdDY2WFp0T3VqcWxzQTJiNzcydnMwR2pXVytSNURY?= =?utf-8?B?QWsxK2Y2MzRnYkdzVjJ0eU9lZXhTYmh4YTlwSVlBeDNnOHZ2SFBIalVkUjNH?= =?utf-8?B?czBXTkZrY0c4TlU2SE42WHl0eXlmSnFhZ1luWVpPbDhOVWtzNjYzdkpzd1hk?= =?utf-8?B?NnpJTE9WazZiS2I1WGRKeEx2ejRkQTJQODVNVUNEaFBaYndyakEvdW1XSFIy?= =?utf-8?B?VFI4MnFWZ21CeVVELzlIRjJyb2x3MVIrY0h2V0hZNWVFUmw4Q0pvdVZWaExK?= =?utf-8?B?NGxMazJWZFQyS1VaYnZDOStnbkdmU2N6YXdFSE5sa2cwYUFxM3plbVFrRzNr?= =?utf-8?B?bDd6QkNVTU1aN2ZnNnlTay9sQjVJaUN1UnQ1YU8zVndsVityS21CVFNMZUV6?= =?utf-8?B?MG44ZWlMYk5paXAxTnZzT3JQanVhRWxiL2gvYjhySmFxZSthSC9hU3RQSE54?= =?utf-8?B?TWsyM3Z1a0VHS09nalorRDN0VlJuTWQzb2VhYXIzY0pVMXVPU1RJNElTYzI1?= =?utf-8?Q?IJro6PEdNbclEaluROETHa8=3D?= X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;6:229EYAWMFSVABkX1rtk2/wy+m8evLyjylW6L5QH373Rp+jJkVVWYRvf+IANjdwMiimc08FhutbZtgXZ0lU7RuPwB/xfFE8Ven3OCTghwHTPZrYaYqVnOPZ9CpcJnfSIH4gVGZnaw0Deou7NwH4y6wiVvUXU8rgzJkHhUQ7zsmh5n2BeLOvh33Io9wo7eHZ92s9CKj4Ksr+Uf4syG7Wmjv+5zlKU8S3Be68EE6NP8g9zkH0vaVRtTQnAV8R2Nod/gJqXj0KO6Wo39ycWkFB4u7VPWTz716ES0/F4Fb8b5L3Mna8TZ9bhfhm2SFwYEkOM1U9CxDICrtuNVXW9zMaJvnTSV8O9/lWoKZm153TIu1dEyqrCpFGSXuYxj7inhj+Rrb4Lyb5e1CfVt3hwMY1X//fWSgun4KGa6d1kF/xRv3QHuERuSwqFgwizyRWekYryn;5:PTknrLVlV7zqN+FeYUEimZP9fcY7iELoQmbRYt9/SEpB/bPhWL8pJeEHKcYopjFGoedbfs0nyv32O7NeRNrOhJ1HJAcS4x+S/9WQas8gWkQsuKrXJwG5cD/ZOM2ZBWqtn6/9zEVLpNgU252w5geecg==;24:cAfNe/kli3kBbkV+/O8n59ZRoantI0G2M5XsbSzK5a547B+aBHO8jgTn34psa9hQjB2rcx5eb9dOUeeHYniNNpHaseuOZp8BQ9/TEGr1xfo= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;CY4PR11MB1637;7:28+UaK3nl9xiSjuojBPJp0HlRBWG5MnbvrRemnVbHmwxGsjON8PDYfQZradd5XLZxbA8dQH2KTpT03KfsL8DYOPhOZV+SAsmw008jHTDaJWU62bAKxLAxsP23y0MRSIXlolholw/IshwzxN/k453iPduU0GRi/yKQCV3rruu00ttQ1ZIzuxjdlt9aHwJh3h48xNptXilaZaubBp9d3lM2k2kK3uFa+v2zqHy21V4ceSBoIs7de/5Wc/GjLD62MQLltsGxh+CZHL18YCmCp2SkprRuQAuya1FLIB2SbvuEelFWJqoEsQw3kLLodvp/2+OURwe0ROMVEMq2sdfDTRcieh/FaLn/uxW+UySvoNl7Oi/ScIjyV0XuYuo4uXeq82qBHZBL4pVHnsfIib/oRYX2vG11n0604OPwWqiQ1G6HPIBhOIW0VxMmQC83qcNDB1lYR/SIuuH9byLHbDLJEAe9g== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 23 Jan 2017 15:16:49.2045 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY4PR11MB1637 X-Pg-Spam-Score: -3.1 (---) 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/20/17 9:06 AM, Stephen Frost wrote: > All the pages are the same size, so I'm surprised you didn't consider > just having a format along the lines of: magic+offset+page, > magic+offset+page, magic+offset+page, etc... Keep in mind that if you go that route you need to accommodate BLKSZ <> 8192. -- 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