Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4E3DD9FB562 for ; Fri, 22 Jun 2007 04:41:09 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 90962-09 for ; Fri, 22 Jun 2007 04:41:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from serv1.oss.ntt.co.jp (ns.oss.ntt.co.jp [222.151.198.98]) by postgresql.org (Postfix) with ESMTP id 4AB799FB55C for ; Fri, 22 Jun 2007 04:41:05 -0300 (ADT) Received: from [127.0.0.1] (unknown [172.17.1.114]) by serv1.oss.ntt.co.jp (Postfix) with ESMTP id A7FDC104001; Fri, 22 Jun 2007 16:41:03 +0900 (JST) Message-ID: <467B7D24.3040802@oss.ntt.co.jp> Date: Fri, 22 Jun 2007 16:41:24 +0900 From: Toru SHIMOGAKI User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 To: "Joshua D. Drake" CC: Tom Lane , Dan Gorman , pgsql-performance@postgresql.org Subject: Re: PITR Backups References: <7E0807EE-B970-4869-A248-B838E42AD9EE@hi5.com> <9761.1182472005@sss.pgh.pa.us> <467B3459.9030808@oss.ntt.co.jp> <467B3DA6.4010005@commandprompt.com> In-Reply-To: <467B3DA6.4010005@commandprompt.com> Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/511 X-Sequence-Number: 25544 Joshua D. Drake wrote: >> - If we don't use hardware level snapshot operation, it takes long time to take >> a large backup data, and a lot of full-page-written WAL files are made. > > Does it? I have done it with fairly large databases without issue. You mean hardware snapshot? I know taking a backup using rsync(or tar, cp?) as a n online backup method is not so a big problem as documented. But it just take a long time if we handle a terabyte database. We have to VACUUM and other batch processes to the large database as well, so we don't want to take a long time to take a backup... Regards, -- Toru SHIMOGAKI NTT Open Source Software Center