Re: generalizing the planner knobs - Mailing list pgsql-hackers

From Tom Lane
Subject Re: generalizing the planner knobs
Date
Msg-id 12408.1134065230@sss.pgh.pa.us
Whole thread Raw
In response to Re: generalizing the planner knobs  (Jaime Casanova <systemguards@gmail.com>)
Responses Re: generalizing the planner knobs
List pgsql-hackers
Jaime Casanova <systemguards@gmail.com> writes:
>> BTW, there's another end to the 'enable_seqscan=false' problem... it
>> sometimes doesn't work!

> I have often considered that this is an indication that seq scan is
> actually the better plan...

There are cases where it is the *only* plan, eg, you have no relevant
indexes.  I am not sure that applies to Jim's complaint though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: bgwriter leaks resources after errors
Next
From: Simon Riggs
Date:
Subject: Re: Reducing contention for the LockMgrLock