Skip site navigation (1) Skip section navigation (2)

Re: IN list processing performance (yet again)

From: Mario Weilguni <mweilguni(at)sime(dot)com>
To: Dave Tenny <tenny(at)attbi(dot)com>,Andreas Pflug <Andreas(dot)Pflug(at)web(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: IN list processing performance (yet again)
Date: 2003-05-28 18:29:43
Message-ID: 200305282029.44152.mweilguni@sime.com (view raw or flat)
Thread:
Lists: pgsql-performance
> 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).

MIN/MAX is almost in every case replaceable:
select bar
   from foo
 order by bar limit 1;

instead of
select max(bar) from foo;



In response to

Responses

pgsql-performance by date

Next:From: Bruno Wolff IIIDate: 2003-05-28 18:39:14
Subject: Re: IN list processing performance (yet again)
Previous:From: Dave TennyDate: 2003-05-28 18:17:21
Subject: Re: IN list processing performance (yet again)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group