Re: Postgres performance comments from a MySQL user

From: Kaarel <kaarel(at)future(dot)ee>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: Jay O'Connor <joconnor(at)cybermesa(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres performance comments from a MySQL user
Date: 2003-06-11 19:01:46
Message-ID: 3EE77C9A.30805@future.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Diogo de Oliveira Biazus 2003-06-11 19:18:43 Re: tsearch v2
Previous Message Dann Corbit 2003-06-11 18:41:26 Re: Index not being used in MAX function (7.2.3)