Re: Postgres performance comments from a MySQL user - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: Postgres performance comments from a MySQL user
Date
Msg-id 3EE797C9.5080102@selectacast.net
Whole thread Raw
In response to Re: Postgres performance comments from a MySQL user  (Justin Clift <justin@postgresql.org>)
Responses Re: Postgres performance comments from a MySQL user  (Justin Clift <justin@postgresql.org>)
List 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?


pgsql-general by date:

Previous
From: Steve Lane
Date:
Subject: Re: Postgres performance comments from a MySQL user
Next
From: Dennis Gearon
Date:
Subject: Re: Postgres performance comments from a MySQL user