Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Rod Taylor
> So are we eliminating the autocommit GUC entirely, or just from > postgresql.conf? It's a client side feature now. Completely gone from the server. -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc signature.asc Description: This is a digitally signed message part

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > So are we eliminating the autocommit GUC entirely, or just from > postgresql.conf? Entirely --- putting it on the server side was a bad mistake, in hindsight. The functionality is better provided on the client side. (The GUC var does still physically ex

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Josh Berkus
Tom, > Yes. It's toast ... didn't you see that flamewar a couple months ago? Nope, missed it. There's enough traffic on this list that I ignore anything that I'm not working on. So are we eliminating the autocommit GUC entirely, or just from postgresql.conf? (I never used the setting, mys

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > Also, Autocommit seems to be gone from postgresql.conf.sample. Was this > intentional? Yes. It's toast ... didn't you see that flamewar a couple months ago? regards, tom lane ---(end of broadcast)-

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Josh Berkus
Tom, Also, Autocommit seems to be gone from postgresql.conf.sample. Was this intentional? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Josh Berkus
Tom, I'm noticing re-namining of a lot of GUCs. As far as I can tell, the re-naming is based on logical reasons -- for example, "log_hostname" is more accurate that "hostname_lookup" -- but was a little surprised. We'd better warn users who are upgrading -- -Josh Berkus Aglio Database

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Bruce Momjian
One issue is that these settings don't even exist in most builds unless you add compiler flags. --- Josh Berkus wrote: > Jan, > > > No, not documenting it IS a good move. > > I couldn't disagree more. Undocumented options

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Jan Wieck
Okay, separate documentation might work ;-) Jan Josh Berkus wrote: Jan, No, not documenting it IS a good move. I couldn't disagree more. Undocumented options? Who are we, Microsoft? If there's a button people will press it, if there's a switch people will turn it on and if there's a slo

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Josh Berkus
Jan, > No, not documenting it IS a good move. I couldn't disagree more. Undocumented options? Who are we, Microsoft? > If there's a button people will > press it, if there's a switch people will turn it on and if there's a > slot people will stick in whatever they have ... believe it or

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Jan Wieck
Justin Clift wrote: Tom Lane wrote: Josh Berkus <[EMAIL PROTECTED]> writes: "wal_debug" is seldom used outside of Postgresql source development or unusual system failures, and should therefore go last. BTW, it occurs to me that wal_debug is one of the hacker-only variables that probably ought not

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Bruce Momjian
Nigel J. Andrews wrote: > On Mon, 9 Jun 2003, Tom Lane wrote: > > > Josh Berkus <[EMAIL PROTECTED]> writes: > > > Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the > > > option that's supposed to let you turn off "Inserting missing FROM clause for > > > table ..." > > > >

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Nigel J. Andrews
On Mon, 9 Jun 2003, Tom Lane wrote: > Josh Berkus <[EMAIL PROTECTED]> writes: > > Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the > > option that's supposed to let you turn off "Inserting missing FROM clause for > > table ..." > > Bruce hasn't applied that patch yet. I

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Bruce Momjian
Josh Berkus wrote: > Tom, > > Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the > option that's supposed to let you turn off "Inserting missing FROM clause for > table ..." > > I thought that patch was accepted 3 weeks ago? Is this just missing from > postgresql.conf.s

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Bruce Momjian
Josh Berkus wrote: > Tom, Justin, > > > Um, not documenting it is probably not a good move for us, however putting > > it at the end in a section marked "Developer Focused" or something similar > > would probably have the right mix of messages. i.e. "hands off" + "not a > > performance tweak", et

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Josh Berkus
Folks, Attached is another order outline for the Postgresql.conf parameters, updated for 7.4. Please examine it, and then give your opinions on the following: 1) Should "enable_implicit_from" go in the "Version/Platform Compatibility" section where I have it now, or in "CLIENT CONNECTIONS-Sta

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Justin Clift
Tom Lane wrote: Josh Berkus <[EMAIL PROTECTED]> writes: "wal_debug" is seldom used outside of Postgresql source development or unusual system failures, and should therefore go last. BTW, it occurs to me that wal_debug is one of the hacker-only variables that probably ought not be documented at al

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Josh Berkus
Tom, Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the option that's supposed to let you turn off "Inserting missing FROM clause for table ..." I thought that patch was accepted 3 weeks ago? Is this just missing from postgresql.conf.sample? -- -Josh Berkus Aglio Dat

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Josh Berkus
Tom, Justin, > Um, not documenting it is probably not a good move for us, however putting > it at the end in a section marked "Developer Focused" or something similar > would probably have the right mix of messages. i.e. "hands off" + "not a > performance tweak", etc. So, proposal: 1) wal_debug

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Josh Berkus
Tom, > Bruce hasn't applied that patch yet. I believe he's starting to catch > up the patch backlog today, though. > > BTW there is also a pending patch that will add a GUC variable to > control "rendezvous" on Darwin. I had forgotten what-all was in the > patch queue until I looked this mornin

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the > option that's supposed to let you turn off "Inserting missing FROM clause for > table ..." Bruce hasn't applied that patch yet. I believe he's starting to catch up the patch back

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-08 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > I think this was touched on before, but was there a final determination > of the ordering of the "show all" command? SHOW ALL will remain alphabetical. regards, tom lane ---(end of broadcast)--

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-08 Thread Bruce Momjian
I think people thought if you were doing SHOW ALL, you were looking for a specific variable, so alphabetical was best. --- Robert Treat wrote: > On Thu, 2003-06-05 at 11:23, Josh Berkus wrote: > > > > 4) Does anyone else ha

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-08 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > "wal_debug" is seldom used outside of Postgresql source development or unusual > system failures, and should therefore go last. BTW, it occurs to me that wal_debug is one of the hacker-only variables that probably ought not be documented at all. I cannot

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-08 Thread Robert Treat
I kind of prefer the way things were grouped together in 7.2 vs. 7.3. If I needed to check out connection information or look at query tuning flags, they were all right next to each other and I didn't have to scroll back and forth through the list. Luckily most of the topical variables share so

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-08 Thread Josh Berkus
Rod, > > 4) Does anyone else have any comments on the proposed re-ordering? > > Since we're painting a shed, does it make sense to put the items in > alphabetical order for each section? I thought about that, yes. However, I find that most items have a logical order that is not alphabetical.

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-08 Thread Rod Taylor
On Thu, 2003-06-05 at 14:16, Josh Berkus wrote: > Rod, > > > > 4) Does anyone else have any comments on the proposed re-ordering? > > > > Since we're painting a shed, does it make sense to put the items in > > alphabetical order for each section? > > I thought about that, yes. However, I find

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-07 Thread Rod Taylor
> 4) Does anyone else have any comments on the proposed re-ordering? Since we're painting a shed, does it make sense to put the items in alphabetical order for each section? -- Rod Taylor <[EMAIL PROTECTED]> PGP Key: http://www.rbt.ca/rbtpub.asc signature.asc Description: This is a digitally

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-07 Thread Robert Treat
On Thu, 2003-06-05 at 11:23, Josh Berkus wrote: > > 4) Does anyone else have any comments on the proposed re-ordering? > I think this was touched on before, but was there a final determination of the ordering of the "show all" command? I'm hoping that will return in the new order of the postgres

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-06 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > 1) Are any additional changes expected for GUC.c before feature-freeze? I'm still thinking of adding an am_superuser variable so that psql can rely on the new ParameterStatus mechanism instead of explicit queries to find out if you're superuser. But this

[HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-06 Thread Josh Berkus
Folks, Last we talked (before the mail server went down) Tom had agreed in principle to a re-ordering of postgresql.conf.sample and the "Run-Time Configuration" docs page based on the attached ordering file. I would like to make this happen before feature-freeze on June 15. To do that, I nee