I am reposting as my original query was mangled
The link to the explain plan is here as it does not paste well into
the email body.
http://explain.depesz.com/s/kHa
The machine is a 2 cpu quad core 5430 with 32G RAM and 6x450G 15K
single raid-10 array
1G work_mem
default_statistics_target=1000
random_page_cost=1
I am curious why the hash join takes so long. The main table
dev4_act_dy_fact_2010_05_t has 25 million rows. The table is
partitioned into 3 parts per month. Remaining tables are very small (
< 1000 rows)