Re: Postgres performance comments from a MySQL user

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: Justin Clift <justin(at)postgresql(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres performance comments from a MySQL user
Date: 2003-06-11 20:57:45
Message-ID: 3EE797C9.5080102@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Justin Clift 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.
>
> Tell him to test it with decent settings (try about 4000 for each as an
> initial start),

Perhaps that should be in the message that 'make install' echoes and in comments in the
conf file itself?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-06-11 21:14:55 Re: Postgres performance comments from a MySQL user
Previous Message Roderick A. Anderson 2003-06-11 20:49:52 Schemas