Re: Simple postgresql.conf wizard

On Thu, 2008-11-13 at 18:07 -0500, Greg Smith wrote:
> On Thu, 13 Nov 2008, Josh Berkus wrote:

> Since Josh's latest parameter model takes a database size as an input,
> perhaps a reasonable way to proceed here is to put the DW model into size
> tiers. Something like this:
>
> DW default_statistics_target:
>
> db size setting
> <1GB 10
> 1GB-10GB 50
> 10GB-100GB 100
> 100GB-1TB 200
> >1TB 400
>
> Going along with my idea that this tool should produce a reasonable result
> with minimal data, I was thinking of making the database size default to
> 10GB if there isn't any input given there. That would give someone who
> specified DW but nothing else a result of 100, which seems a less
> controversial setting.
>

Why are we building wizards for settings that will be configured by
experts? I thought the idea here was:

Simple postgresql.conf wizard

If you are running a DW you are beyond the point of this tool are you
not?

Joshua D. Drake

> --
> * Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
>
--