On Mon, Dec 14, 2015 at 8:38 AM, Amit Kapila <amit.kapil...@gmail.com> wrote: > set enable_hashjoin=off; > set enable_mergejoin=off;
[ ... ] > Now here the point to observe is that non-parallel case uses both less > Execution time and Planning time to complete the statement. There > is a considerable increase in planning time without any benefit in > execution. So, you forced the query planner to give you a bad plan, and then you're complaining that the plan is bad? That's not a very surprising result. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers