X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5E3E1D70DD for ; Sun, 20 Nov 2005 04:56:06 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24299-04 for ; Sun, 20 Nov 2005 08:56:07 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from linda-4.paradise.net.nz (bm-4a.paradise.net.nz [203.96.152.183]) by svr1.postgresql.org (Postfix) with ESMTP id DB76AD6EEA for ; Sun, 20 Nov 2005 04:56:03 -0400 (AST) Received: from smtp-1.paradise.net.nz (tclsnelb2-src-1.paradise.net.nz [203.96.152.177]) by linda-4.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IQ800FNCWTGCJ@linda-4.paradise.net.nz> for pgsql-performance@postgresql.org; Sun, 20 Nov 2005 21:56:04 +1300 (NZDT) Received: from [192.168.1.11] (218-101-29-89.dsl.clear.net.nz [218.101.29.89]) by smtp-1.paradise.net.nz (Postfix) with ESMTP id 343DDFBDC83; Sun, 20 Nov 2005 21:56:04 +1300 (NZDT) Date: Sun, 20 Nov 2005 21:55:59 +1300 From: Mark Kirkwood Subject: Re: Hardware/OS recommendations for large databases ( In-reply-to: <437F9919.20305@paradise.net.nz> To: Mark Kirkwood Cc: Luke Lonergan , pgsql-performance@postgresql.org, stange@rentec.com, gsstark@mit.edu, pg@fastcrypt.com, icub3d@gmail.com Message-id: <43803A1F.9030708@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (X11/20051106) References: <437F9919.20305@paradise.net.nz> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.499 required=5 tests=[AWL=0.499] X-Spam-Score: 0.499 X-Spam-Level: X-Archive-Number: 200511/407 X-Sequence-Number: 15664 Mark Kirkwood wrote: > > - I am happy that seqscan is cpu bound after ~110M/s (It's cpu bound on > my old P3 system even earlier than that....) Ahem - after reading Alan's postings I am not so sure, ISTM that there is some more investigation required here too :-).