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 1105B9F946D for ; Wed, 3 May 2006 09:19:08 -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 41431-10 for ; Wed, 3 May 2006 09:19:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms042pub.verizon.net (vms042pub.verizon.net [206.46.252.42]) by postgresql.org (Postfix) with ESMTP id 79BBA9F9586 for ; Wed, 3 May 2006 09:19:00 -0300 (ADT) Received: from osgiliath.mathom.us ([70.108.132.172]) by vms042.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0IYO00A6JVJH6YX1@vms042.mailsrvcs.net> for pgsql-performance@postgresql.org; Wed, 03 May 2006 07:18:53 -0500 (CDT) Received: from localhost (localhost [127.0.0.1]) by osgiliath.mathom.us (Postfix) with ESMTP id B30766EC9D for ; Wed, 03 May 2006 08:18:50 -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 14209-03 for ; Wed, 03 May 2006 08:18:50 -0400 (EDT) Received: by osgiliath.mathom.us (Postfix, from userid 1000) id BB5986ECBD; Wed, 03 May 2006 08:18:49 -0400 (EDT) Date: Wed, 03 May 2006 08:18:49 -0400 From: Michael Stone Subject: Re: Slow restoration question In-reply-to: <4A7F9950-65E0-4FA5-9FEC-BA1A93E615E5@clickspace.com> To: pgsql-performance@postgresql.org Mail-followup-to: pgsql-performance@postgresql.org Message-id: <20060503121847.GN31328@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> User-Agent: Mutt/1.5.11+cvs20060403 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/80 X-Sequence-Number: 18867 On Tue, May 02, 2006 at 08:09:52PM -0600, Brendan Duddridge wrote: > -------Sequential Output-------- ---Sequential Input-- --Random-- > -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- >Machine MB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec % CPU /sec %CPU > 0 40365 99.4 211625 61.4 212425 57.0 50740 99.9 730515 100.0 45897.9 190.1 [snip] >Do these numbers seem decent enough for a Postgres database? These numbers seem completely bogus, probably because bonnie is using a file size smaller than memory and is reporting caching effects. (730MB/s isn't possible for a single external RAID unit with a pair of 2Gb/s interfaces.) bonnie in general isn't particularly useful on modern large-ram systems, in my experience. Mike Stone