X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 347C89233A2 for ; Wed, 28 May 2003 14:37:05 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 07115-02 for ; Wed, 28 May 2003 14:37:03 -0400 (EDT) Received: from wolff.to (wolff.to [66.93.249.74]) by developer.postgresql.org (Postfix) with SMTP id 0D3B292334A for ; Wed, 28 May 2003 14:37:03 -0400 (EDT) Received: (qmail 6140 invoked by uid 500); 28 May 2003 18:39:14 -0000 Date: Wed, 28 May 2003 13:39:14 -0500 From: Bruno Wolff III To: Dave Tenny Cc: Andreas Pflug , pgsql-performance@postgresql.org Subject: Re: IN list processing performance (yet again) Message-ID: <20030528183914.GA6118@wolff.to> Mail-Followup-To: Dave Tenny , Andreas Pflug , pgsql-performance@postgresql.org References: <3ED4B0E5.3050703@attbi.com> <3ED4B75A.2050106@web.de> <3ED4FB02.1010908@attbi.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <3ED4FB02.1010908@attbi.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/244 X-Sequence-Number: 2023 On Wed, May 28, 2003 at 14:08:02 -0400, Dave Tenny wrote: > Andreas Pflug wrote: > > I'm reminded to relay to the PostgreSQL devos that I might be able to do > more in the join or subquery department if > PostgreSQL had better performing MAX functions and a FIRST function for > selecting rows from groups. > ("Performing" being the operative word here, since the extensible > architecture of PostgreSQL currently makes for poorly > performing MAX capabilities and presumably similar user defined > aggregate functions). Have you tried replacing max with a subselect that uses order by and limit?