X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CCFCFD1B500 for ; Fri, 3 Oct 2003 22:04:46 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 52926-04 for ; Fri, 3 Oct 2003 19:03:59 -0300 (ADT) Received: from five.zapatec.com (66-117-150-100.web.lmi.net [66.117.150.100]) by svr1.postgresql.org (Postfix) with ESMTP id CD294D1B502 for ; Fri, 3 Oct 2003 19:03:56 -0300 (ADT) Received: from rlx11.zapatec.com (rlx11.pr.zapatec.com [192.168.1.132]) by five.zapatec.com (Postfix) with ESMTP id 0EB0D5FE7 for ; Fri, 3 Oct 2003 22:03:59 +0000 (GMT) Received: (from dror@localhost) by rlx11.zapatec.com (8.12.3/8.12.3/Submit) id h93M3wl7097475 for pgsql-performance@postgresql.org; Fri, 3 Oct 2003 15:03:58 -0700 (PDT) (envelope-from dror) Date: Fri, 3 Oct 2003 15:03:58 -0700 From: Dror Matalon To: pgsql-performance@postgresql.org Subject: Re: Speeding up Aggregates Message-ID: <20031003220358.GR87525@rlx11.zapatec.com> References: <20031003202120.GO87525@rlx11.zapatec.com> <200310031407.10343.josh@agliodbs.com> <20031003212848.GP87525@rlx11.zapatec.com> <200310031435.46838.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200310031435.46838.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/114 X-Sequence-Number: 3862 On Fri, Oct 03, 2003 at 02:35:46PM -0700, Josh Berkus wrote: > Dror, > > > I am using 7.4, and had tried NOT EXISTS and didn't see any > > improvements. > > It wouldn't if you're using 7.4, which has improved IN performance immensely. > > What happens if you stop using a function and instead use a subselect? An improvement. Now I'm getting in the 200 msec response time. And by the way, I tried "not exists" again and it actually runs slower than "not in." > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly -- Dror Matalon Zapatec Inc 1700 MLK Way Berkeley, CA 94709 http://www.zapatec.com