Re: Auto-tuning work_mem and maintenance_work_mem - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Auto-tuning work_mem and maintenance_work_mem
Date
Msg-id 5256F7A1.6080305@gmx.net
Whole thread Raw
In response to Re: Auto-tuning work_mem and maintenance_work_mem  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On 10/10/13 11:45 AM, Bruce Momjian wrote:
> I think the big win for a tool would be to query the user about how they
> are going to be using Postgres, and that can then spit out values the
> user can add to postgresql.conf, or to a config file that is included at
> the end of postgresql.conf.

I think such a tool would actually make the initial experience worse for
many people.  Quick, how are you going to use your PostgreSQL server:

- OLTP
- web
- mixed

Uh, all of the above?  This sort of thing can quickly turn the "first 15
minutes" into the first 2 hours, as users are forced to analyze the
different settings, have second thoughts, wonder about how to change
them back, etc.  The fewer decisions people have to make initially, the
better.  The initdb phase already has too many required decisions that
can cause regret later (e.g., locale, encoding, checksums).




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: dynamic shared memory: wherein I am punished for good intentions
Next
From: Fujii Masao
Date:
Subject: Re: strange behavior of pg_trgm's similarity function