Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id CAF03B5DBBF
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 26 May 2011 15:04:44 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 33205-10
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 26 May 2011 18:04:37 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sam.nabble.com (sam.nabble.com [216.139.236.26])
	by mail.postgresql.org (Postfix) with ESMTP id F2BF5B5D832
	for <pgsql-performance@postgresql.org>;
	Thu, 26 May 2011 15:04:36 -0300 (ADT)
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <panam@gmx.net>) id 1QPevD-0004Fn-7F
	for pgsql-performance@postgresql.org; Thu, 26 May 2011 11:04:35 -0700
Date: Thu, 26 May 2011 11:04:35 -0700 (PDT)
From: panam <panam@gmx.net>
To: pgsql-performance@postgresql.org
Message-ID: <1306433075215-4429475.post@n5.nabble.com>
In-Reply-To: <4DDE42B2020000250003DD5E@gw.wicourts.gov>
References: <4DDB47BC.8030504@postnewspapers.com.au>
	<1306247697267-4422247.post@n5.nabble.com>
	<4DDC6109.7060708@postnewspapers.com.au>
	<1306341749094-4425890.post@n5.nabble.com>
	<4DDDBD96.4010809@postnewspapers.com.au>
	<1306413217406-4428435.post@n5.nabble.com>
	<BANLkTin6XpuCUCk97R6MNcuwd8bVvJ3ZcQ@mail.gmail.com>
	<4DDE21FE020000250003DD49@gw.wicourts.gov>
	<1306426087061-4429125.post@n5.nabble.com>
	<4DDE42B2020000250003DD5E@gw.wicourts.gov>
Subject: Re: Hash Anti Join performance degradation
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.767 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01,
	URI_HEX=1.122
X-Spam-Level: 
X-Archive-Number: 201105/384
X-Sequence-Number: 43893

Sorry,

SELECT MAX(e.id) FROM event_message e WHERE e.box_id = id

as posted previously should actually read

SELECT max(m1.id) FROM message m1 WHERE m1.box_id = b.id)

so I tried this already.

Regards,
panam




--
View this message in context: http://postgresql.1045698.n5.nabble.com/Hash-Anti-Join-performance-degradation-tp4420974p4429475.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.