Re: Simple postgresql.conf wizard

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

In response to

Browse pgsql-hackers by date

  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