On Mon, Dec 14, 2015 at 8:38 AM, Amit Kapila <amit.kapila16@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