Postgres Pro
Downloads
Home   >   mailing lists

Re: Hash Anti Join performance degradation - Mailing list pgsql-performance

From panam
Subject Re: Hash Anti Join performance degradation
Date
Msg-id 1306433075215-4429475.post@n5.nabble.com
Whole thread Raw
In response to Re: Hash Anti Join performance degradation  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: The shared buffers challenge
Next
From: Cédric Villemain
Date:
Subject: Re: Hash Anti Join performance degradation