From: | Jim Nasby <decibel(at)decibel(dot)org> |
---|---|
To: | Michael Stone <mstone+postgres(at)mathom(dot)us> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Feature Request --- was: PostgreSQL Performance Tuning |
Date: | 2007-04-27 16:12:21 |
Message-ID: | 1EEBDF47-F5E5-477E-B6A2-4F2D2E097F59@decibel.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
On Apr 27, 2007, at 3:30 PM, Michael Stone wrote:
> On Fri, Apr 27, 2007 at 09:27:49AM -0400, Carlos Moreno wrote:
>> Notice that the second part of my suggestion covers this --- have
>> additional
>> switches to initdb so that the user can tell it about estimates on
>> how the DB
>> will be used: estimated size of the DB, estimated percentage of
>> activity that
>> will involve writing, estimated percentage of activity that will
>> be transactions,
>> percentage that will use indexes, percentage of queries that will
>> be complex,
>> etc. etc.
>
> If the person knows all that, why wouldn't they know to just change
> the config parameters?
Because knowing your expected workload is a lot easier for many
people than knowing what every GUC does.
Personally, I think it would be a tremendous start if we just
provided a few sample configs like MySQL does. Or if someone wanted
to get fancy they could stick a web page somewhere that would produce
a postgresql.conf based simply on how much available RAM you had,
since that's one of the biggest performance-hampering issues we run
into (ie: shared_buffers left at the default of 32MB).
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
From | Date | Subject | |
---|---|---|---|
Next Message | John D. Burger | 2007-04-27 17:06:42 | Re: Processing a work queue |
Previous Message | Michael Stone | 2007-04-27 15:30:33 | Re: Feature Request --- was: PostgreSQL Performance Tuning |
From | Date | Subject | |
---|---|---|---|
Next Message | Siddharth Anand | 2007-04-27 16:19:04 | Re: How can fixed and variable width columns perform similarly? |
Previous Message | Richard Huxton | 2007-04-27 16:07:22 | Re: [Fwd: ] How |