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

From Kaarel
Subject Re: Postgres performance comments from a MySQL user
Date
Msg-id 3EE77C9A.30805@future.ee
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  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Postgres performance comments from a MySQL user  (Martin Marques <martin@bugs.unl.edu.ar>)
List 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.


pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Index not being used in MAX function (7.2.3)
Next
From: culley harrelson
Date:
Subject: tsearch v2