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 8A6409FA195 for ; Wed, 3 May 2006 17:53:24 -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 84942-10 for ; Wed, 3 May 2006 17:53:13 -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 3DC0C9F9C10 for ; Wed, 3 May 2006 17:53:12 -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 <0IYP00GH8JCMZES1@vms040.mailsrvcs.net> for pgsql-performance@postgresql.org; Wed, 03 May 2006 15:53:11 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id DDFD36E6C0 for ; Wed, 03 May 2006 16:53:09 -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 17932-03-3 for ; Wed, 03 May 2006 16:53:09 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id EACD86ECBE; Wed, 03 May 2006 16:53:08 -0400 (EDT) Date: Wed, 03 May 2006 16:53:08 -0400 From: Michael Stone Subject: Re: Slow restoration question In-reply-to: <1146685215.22037.46.camel@state.g2switchworks.com> To: pgsql-performance@postgresql.org Mail-followup-to: pgsql-performance@postgresql.org Message-id: <20060503205306.GB16533@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: <20060502215329.GI97354@pervasive.com> <4A7F9950-65E0-4FA5-9FEC-BA1A93E615E5@clickspace.com> <20060503121847.GN31328@mathom.us> <30D5959B-3CCD-4CB4-B2D7-30DEA9F08BB6@torgo.978.org> <20060503155938.GO31328@mathom.us> <1146672434.22037.38.camel@state.g2switchworks.com> <20060503170604.GP31328@mathom.us> <20060503180821.GZ97354@pervasive.com> <20060503192652.GA16533@mathom.us> <1146685215.22037.46.camel@state.g2switchworks.com> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/94 X-Sequence-Number: 18881 On Wed, May 03, 2006 at 02:40:15PM -0500, Scott Marlowe wrote: >Note that I'm referring to bonnie++ as was an earlier poster. It >certainly seems capable of giving you a good idea of how your hardware >will behave under load. IME it give fairly useless results. YMMV. Definately the numbers posted before seem bogus. If you have some way to make those figures useful in your circumstance, great. Too often I see people taking bonnie numbers at face value and then being surprised that don't relate at all to real-world performance. If your experience differs, fine. Mike Stone