Re: Removing postgres -f command line option - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Removing postgres -f command line option
Date
Msg-id 1321536266-sup-5583@alvh.no-ip.org
Whole thread Raw
In response to Re: Removing postgres -f command line option  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
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.linnakangas@enterprisedb.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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Removing postgres -f command line option
Next
From: Alvaro Herrera
Date:
Subject: Re: Configuration include directory