Thank you for the answer This is a miss understanding of hash join behaviour on my side.
That means that there is at less on line read in facts_p2 part even if the second table partition of the hash join operation is empty. I will remember it now ;o) Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html