Tatsuo Ishii <ishii@xxxxxxxxxxxxxx> writes: > Just out of curiosity, is there any chance that this kind of query is > speeding up in 9.1 because of following changes? > * Allow FULL OUTER JOIN to be implemented as a hash join, and allow > either side of a LEFT OUTER JOIN or RIGHT OUTER JOIN to be hashed > (Tom Lane) The given query wasn't an outer join, so this wouldn't affect it. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance