Kris Jurka <books@xxxxxxxxxx> writes: > The hash join takes less than twenty seconds, the other two joins I > killed after five minutes. I can try to collect explain analyze results > later today if you'd like. Please, unless the test case you already posted has similar behavior. 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