Re: Removing postgres -f command line option

Excerpts from Robert Haas's message of jue nov 17 10:14:21 -0300 2011:
> On Thu, Nov 17, 2011 at 4:19 AM, Heikki Linnakangas
> <heikki(dot)linnakangas(at)enterprisedb(dot)com> wrote:
> > While looking at Shigeru Hanada's foreign join pushdown patch, I noticed a
> > command line option that I didn't know to exist:
> >
> > $ postgres --help
> > ...
> > Developer options:
> >  -f s|i|n|m|h    forbid use of some plan types
> >
> > That doesn't include all the options we support, the documentation lists:
> > s|i|o|b|t|n|m|h. These are aliases for enable_* planner options, e.g -fs is
> > equal to enable_seqscan=off.
> >
> > That seems completely useless to me, because you can also do "-c
> > enable_seqscan=off". Any objections to removing the -f option altogether?
>
> No. Seems useless to me.

Dunno. It seems awfully convenient if you're testing optimizer stuff
that requires turning one of these off, though of course I haven't ever
done that. The alternative requires a lot more keystrokes. It doesn't
matter to me either way, though. (To be honest I wasn't aware of these
options -- not sure if I'll use them in the future)

$ PGOPTIONS=-fs psql
psql (9.2devel)
Digite «help» para obtener ayuda.

alvherre=# show enable_seqscan ;
enable_seqscan
----------------
off
(1 fila)

$ PGOPTIONS="-c enable_seqscan=0" psql
psql (9.2devel)
Digite «help» para obtener ayuda.

alvherre=# show enable_seqscan ;
enable_seqscan
----------------
off
(1 fila)

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support