AminPG Jaffer <aminjaffer(dot)pg(at)gmail(dot)com> writes:> We are facing an issue where the cost shows up "cost=10000000000.00" so> trying to find where that is set.
That means you've turned off enable_seqscan (or one of its siblings)but the planner is choosing a seqscan plan (or other plan type youtried to disable) anyway because it has no other alternative.
> Could anyone point me to the code where the cost "cost=10000000000.00" is> set?
Look for disable_cost.
regards, tom lane