Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id B6789FD3E1E for ; Tue, 12 Jun 2012 12:00:55 -0300 (ADT) Received: from smtp.peak6.com ([38.98.137.6]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SeSaP-00040v-J9 for pgsql-performance@postgresql.org; Tue, 12 Jun 2012 15:00:55 +0000 X-AuditID: 0a64cb1e-b7f856d00000287c-07-4fd7598018e2 Message-ID: <4FD75993.5020803@optionshouse.com> Date: Tue, 12 Jun 2012 10:00:35 -0500 From: Shaun Thomas Reply-To: Organization: Peak6 User-Agent: Mozilla/5.0 (X11; Linux i686; rv:12.0) Gecko/20120430 Thunderbird/12.0.1 MIME-Version: 1.0 To: Magnus Hagander CC: "pgsql-performance@postgresql.org" Subject: Re: Performance of pg_basebackup References: <4FD75824.9000005@optionshouse.com> In-Reply-To: Content-Type: text/plain; charset="ISO-8859-1"; format=flowed content-transfer-encoding: 7bit X-Originating-IP: [10.10.201.64] X-Brightmail-Tracker: H4sIAAAAAAAAA+NgFrrHIsWRmVeSWpSXmKPExsXClcIrptsQed3fYPcOcYsVn+6wWlyfeY7Z gcljU9txZo8L+6axBzBFNTDaJObl5ZcklqQqpKQWJ9sq+ReUZObnFXvklxanKrhkFifnJGbm phYpKWSm2CqZKykU5CQmp+am5pXYKiUWFKTmpSjZcSlgABugssw8hdS85PyUzLx0WyXPYH9d CwtTS11DJbt4ZJDQyZKxpXETY8Fc1ortL/awNzDOYuli5OSQEDCR2L3zPRuELSZx4d56IJuD g1dAX2Lt5xCQMIuAqsTWQ2vBStgEdCUm9a8As4UEVCT6zt5gArH5BYQl9n1oYgaxRQVCJM49 +Q5WwysgKHFy5hOwVSICmhKf5h5mBLGZBTwlOk6tArOFBYwlbt+6ygIxs0Ri26PvYHFOgUCJ K1+3M0PU20pcmHOdBcKWl9j+dg4zRL2qxIrmiVDnK0j8v/KOaQKj0Cwkq2chaZ+FpH0BI/Mq RvHissTkjEzTguLckgJDvYLUxGwzvbzUkk2M4Lg9LbeDcfpSxUOMAhyMSjy8AirX/IVYE8uK K3MPMUpwMCuJ8OqHXfcX4k1JrKxKLcqPLyrNSS0+xGgKDLOJzFKiyfnAlJJXEm9obGhpamli ZmlubGygJM77a+0ZfyGBdGBqyE5NLUgtgulj4uCUamCsNZ0qnWf87tEx22SNtxIqlqenhZpN sWvgZnnOVsduYzotqjN4f0fgBEPO/JMLt5WHMMb2rZN5U/H0tv4X/eMh708GW6q92HAm+aGR TNC+/cfv95tzKdlyXnx+44LH3cfPN8UFzc8/HaNyiHfLQ6abq/PUd2zd01ow5zXHhA+WZQwJ m7/P82tWYinOSDTUYi4qTgQAuRBhH/ECAAA= X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201206/71 X-Sequence-Number: 47097 On 06/12/2012 09:57 AM, Magnus Hagander wrote: > If you have a single tablespace you can have pg_basebackup write the > output to stdout and then pipe that through pigz. Yeah, I saw that. Unfortunately we have tiered storage and hence two tablespaces. :( To be fair, my current process cheats by following symlinks. I haven't yet modified it to explicitly handle tablespaces. I'll probably just steal the directory method pg_basebackup uses until it can natively call an external compression program. Thanks, Magnus! -- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 sthomas@optionshouse.com ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email