AminPG Jaffer <[email protected]> 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 you
tried 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
