Re: Oracle rant - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Oracle rant
Date
Msg-id Pine.LNX.4.44.0301161950540.789-100000@localhost.localdomain
Whole thread Raw
In response to Re: Oracle rant  (Adrian 'Dagurashibanipal' von Bidder <avbidder@fortytwo.ch>)
List pgsql-hackers
Adrian 'Dagurashibanipal' von Bidder writes:

>  - postgres should auto-tune itself - the *cost could perhaps be
> adjusted after some statistics have been collected, and there should be
> some sensible way to determine an optimal setting for the famous
> shared_buffers (and the default should be something that gets reasonable
> performance on common cases)

Over the last couple of years PostgreSQL has transformed from hardly
configurable to fully configurable.  Currently we're in a mode where we
add new configuration parameters whenever there's a degree of uncertainty.
Sooner rather than later we need to shift to the next phase, which is as
you say autoconfiguration, because ease of administration is one of the
great advantages of PostgreSQL.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgresql code
Next
From: Peter Eisentraut
Date:
Subject: Re: copying perms to another user