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.linnakan...@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 <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
