From: | "Robert Haas" <robertmhaas(at)gmail(dot)com> |
---|---|
To: | "Gregory Stark" <stark(at)enterprisedb(dot)com> |
Cc: | "Greg Smith" <gsmith(at)gregsmith(dot)com>, "Josh Berkus" <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Simple postgresql.conf wizard |
Date: | 2008-12-04 05:54:50 |
Message-ID: | 603c8f070812032154pf548718g3cbd3cbab4406b2d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> If we do though, it shouldn't default one way and then get randomly flipped by
> a tool that has the same information to make its decision on. What I'm saying
> is that "mixed" is the same information that initdb had about the workload.
+1.
> If we do change this then I wonder if we need the parameter at all. I mean, we
> don't generally have parameters to turn off random parts of the optimizer...
It probably isn't a good idea to both change the default setting and
remove the parameter in the same release. It would be awesome if this
is cheap enough now to have it on by default - but constraints are
pretty useful for maintaining data integrity, so it's conceivable to
me that someone could have a lot of constraints most of which are
unuseful for query planning.
...Robert
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2008-12-04 05:56:20 | Re: Simple postgresql.conf wizard |
Previous Message | Mark Wong | 2008-12-04 05:53:12 | Re: Simple postgresql.conf wizard |