Re: PostgreSQL vs. MySQL - Mailing list pgsql-hackers

From johnnnnnn
Subject Re: PostgreSQL vs. MySQL
Date
Msg-id 20030704203957.GA51795@performics.com
Whole thread Raw
In response to Re: PostgreSQL vs. MySQL  (Rod Taylor <rbt@rbt.ca>)
Responses Re: PostgreSQL vs. MySQL
List pgsql-hackers
On Fri, Jul 04, 2003 at 10:49:01AM -0400, Rod Taylor wrote:
> > In my opinion the defaults should be set up for a typical database
> > server machine.
> 
> Ok.. thats fair.  The first problem would be to define typical for
> current PostgreSQL installations, and typical for non-postgresql
> installations (the folks we want to convert).

It's been a while since the last one of these discussions, so stop me
if this has been suggested before, but...

Do we actually want to have a default configuration file?

Seriously, if we provide, say, 4 or 5 files based on various system
assumptions (conf.MINIMAL, conf.AVERAGE, conf.MULTIDISK, or whatever),
then we might be able to get away with not providing an actual
default. Change the installation instructions to say

>>>
PostgreSQL requires a configuration file, which it expects to be
located in $DIR. Provided are several example configurations (in
$DIR/eg/). If you're just starting with PostrgreSQL, we recommend
reading through those and selecting one which most closely matches
your machine.

If you're in doubt as to which file to use, try $AVERAGE. If you're
still having difficulty getting PostgreSQL to run, try
$MINIMAL. $MINIMAL should work on every supported platform, but is not
optimized for modern hardware -- PostgreSQL will not run well in this
configuration.
<<<

This makes the installation process slightly less simple, but only in
the way that we want it to be. That is, it forces the end user to the
realization that there actually is configuration to be done, and
forces them into a minimally interactive way to deal with it.

It also doesn't require any kernel-test coding, or really any
development at all, so we should theoretically be able to get it
finished and ready to go more quickly.

Thoughts?

-johnnnnnnnnnnn


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Proof-of-concept for initdb-time shared_buffers selection
Next
From: David Blasby
Date:
Subject: '_' < '5' -- different answer on 7.2 and 7.3