Re: Simple postgresql.conf wizard

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Gregory Stark <stark(at)enterprisedb(dot)com>, jd(at)commandprompt(dot)com, Robert Haas <robertmhaas(at)gmail(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 18:20:48
Message-ID: 49381F80.2030208@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Smith wrote:
> I'm not the sort to be too concerned myself that
> the guy who thinks he's running a DW on a system with 64MB of RAM might
> get bad settings, but it's a fair criticism to point that out as a problem.

In defense of thinking about very small configurations, I've seen many
cases where an enterprise-software salesperson's laptop is running a
demo - either in a small virtual machine in the laptop, or on an
overloaded windows box. Even though the customer might end up
running with 64GB, the sales demo's more likely to be 64MB.

In some ways, I'd be more interested in seeing automation of those than
the large production systems. Large production systems are likely to
have an administrator who's paid to read the documentation and learn
how to configure the database. OTOH there tends to be less DBA time
available to tune the smaller demo instances that come&go as sales
people upgrade their laptops; so improved automation would be much
appreciated there.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2008-12-04 18:28:05 Re: Simple postgresql.conf wizard
Previous Message Pavel Stehule 2008-12-04 18:00:45 Re: WIP: default values for function parameters