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 E03D4D8216 for ; Sun, 20 Nov 2005 21:41:14 -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 90856-03 for ; Mon, 21 Nov 2005 01:41:17 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [203.96.152.180]) by svr1.postgresql.org (Postfix) with ESMTP id 49577D7FCE for ; Sun, 20 Nov 2005 21:41:11 -0400 (AST) Received: from smtp-1.paradise.net.nz (tclsnelbe2-src-nat-1 [203.96.152.177]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IQA00APC7C9QN@linda-1.paradise.net.nz> for pgsql-performance@postgresql.org; Mon, 21 Nov 2005 14:40:57 +1300 (NZDT) Received: from [192.168.1.11] (218-101-28-198.dsl.clear.net.nz [218.101.28.198]) by smtp-1.paradise.net.nz (Postfix) with ESMTP id 9D245129F391; Mon, 21 Nov 2005 14:40:56 +1300 (NZDT) Date: Mon, 21 Nov 2005 14:40:54 +1300 From: Mark Kirkwood Subject: Re: Hardware/OS recommendations for large databases ( In-reply-to: <438110A3.20506@paradise.net.nz> To: Mark Kirkwood Cc: Alan Stange , Luke Lonergan , Greg Stark , Dave Cramer , Joshua Marsh , pgsql-performance@postgresql.org Message-id: <438125A6.2040200@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: <437FFEF0.9090409@rentec.com> <438110A3.20506@paradise.net.nz> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.333 required=5 tests=[AWL=0.333] X-Spam-Score: 0.333 X-Spam-Level: X-Archive-Number: 200511/417 X-Sequence-Number: 15674 Mark Kirkwood wrote: > The test is SELECT 1 FROM table That should read "The test is SELECT count(1) FROM table...."