Nimesh Satam wrote: > Thanks for the information. join_collapse_limit = 1 is already set before > sending the query plan. I assume that was a typo, and you really set it to 10 or higher... > Will a index scan on metrics.netkey help in improving the performance what > other configuration parameters should we consider while opting for > partition? Whether it helps or not depends on many things, like the distribution of the data, but it's worth trying. I'd try that first, before worrying about config parameters. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate