Re: Postgres performance comments from a MySQL user

On Mié 11 Jun 2003 16:01, Kaarel wrote:
> > The _very first_ thing to do with any PostgreSQL installation is bump
> > up the memory settings (at least "sort_mem" and "shared_buffers") in
> > the postgresql.conf and restart it.
>
> This makes me wonder why is the default configuration so conservative?
> If this is the very first thing with any postgre installation then
> wouldn't it make more sense to have higher default memory settings and
> these who then have problems could lower the memory settings.

You can't expect to have a good DB server if you didn't take the time to
read the performance tips on the PostgreSQL Administration Guide, and
gone through the postgresql.conf file.
The same goes for any server, httpd, MTA, etc. For small load a default
Apache, or default Postfix will work OK, but on heavy load you have to
make tuning, or the system will fall to pieces.

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------