X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id AA000D1EA55
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Mar 2004 21:48:20 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 05596-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 29 Mar 2004 17:48:20 -0400 (AST)
Received: from davinci.ethosmedia.com (server228.ethosmedia.com
	[209.128.84.228])
	by svr1.postgresql.org (Postfix) with ESMTP id 7FC68D1D29C
	for <pgsql-sql@postgresql.org>; Mon, 29 Mar 2004 17:48:17 -0400 (AST)
Received: from [63.195.55.98] (HELO 192.168.1.29)
	by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8)
	with ESMTP id 4727698; Mon, 29 Mar 2004 13:49:39 -0800
From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: Greg Stark <gsstark@mit.edu>
Subject: Re: Slow sub-selects, max and count(*)
Date: Mon, 29 Mar 2004 13:47:43 -0800
User-Agent: KMail/1.5.4
Cc: "Richard Sydney-Smith" <richard@ibisaustralia.com>,
	<pgsql-sql@postgresql.org>
References: <001001c3eb8a$255d6dc0$5801a8c0@athlon2000>
	<200402042113.01369.josh@agliodbs.com>
	<87brmhtrcs.fsf@stark.xeocode.com>
In-Reply-To: <87brmhtrcs.fsf@stark.xeocode.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200403291347.43035.josh@agliodbs.com>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200403/263
X-Sequence-Number: 17362

Greg,

> Please don't confuse the issue by throwing Max() and Count() into the same
> basket.

When on earth is that post of mine from?  Seems like it's several months, if 
not a couple of years, old.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco