X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9F5019FA372 for ; Wed, 3 May 2006 13:02:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 44750-04 for ; Wed, 3 May 2006 13:02:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by postgresql.org (Postfix) with ESMTP id E7A289F9CC1 for ; Wed, 3 May 2006 13:02:09 -0300 (ADT) Received: from osgiliath.mathom.us ([70.108.132.172]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0IYP00GE65RKYQL0@vms040.mailsrvcs.net> for pgsql-performance@postgresql.org; Wed, 03 May 2006 10:59:45 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id EFA376EC9D; Wed, 03 May 2006 11:59:40 -0400 (EDT) Received: from osgiliath.mathom.us ([127.0.0.1]) by localhost (osgiliath.home.mathom.us [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 15813-03-3; Wed, 03 May 2006 11:59:40 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id 39A6B6ECBE; Wed, 03 May 2006 11:59:40 -0400 (EDT) Date: Wed, 03 May 2006 11:59:39 -0400 From: Michael Stone Subject: Re: Slow restoration question In-reply-to: <30D5959B-3CCD-4CB4-B2D7-30DEA9F08BB6@torgo.978.org> To: Jeff Trout Cc: pgsql-performance@postgresql.org Mail-followup-to: Jeff Trout , pgsql-performance@postgresql.org Message-id: <20060503155938.GO31328@mathom.us> MIME-version: 1.0 Content-type: text/plain; charset=us-ascii; format=flowed Content-disposition: inline X-Pgp-Fingerprint: 53 FF 38 00 E7 DD 0A 9C 84 52 84 C5 EE DF 7C 88 X-Virus-Scanned: Debian amavisd-new at mathom.us References: <444F24E9.2010907@lisasoft.com> <20060502171617.GZ97354@pervasive.com> <622925BE-A31E-42FD-AF6A-68DDF3B4A1B7@clickspace.com> <1146595755.12053.111.camel@archimedes> <758B0591-3C9C-418B-9AF2-E962003C4904@rackspace.com> <20060502215329.GI97354@pervasive.com> <4A7F9950-65E0-4FA5-9FEC-BA1A93E615E5@clickspace.com> <20060503121847.GN31328@mathom.us> <30D5959B-3CCD-4CB4-B2D7-30DEA9F08BB6@torgo.978.org> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/86 X-Sequence-Number: 18873 On Wed, May 03, 2006 at 09:19:52AM -0400, Jeff Trout wrote: >Bonnie++ is able to use very large datasets. It also tries to figure >out hte size you want (2x ram) - the original bonnie is limited to 2GB. Yes, and once you get into large datasets like that the quality of the data is fairly poor because the program can't really eliminate cache effects. IOW, it tries but (in my experience) doesn't succeed very well. Mike Stone