Re: optimal sql - Mailing list pgsql-sql

From Michael Paesold
Subject Re: optimal sql
Date
Msg-id 00a301c2c1fd$8fec4d30$3201a8c0@beeblebrox
Whole thread Raw
In response to Re: optimal sql  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Responses Re: optimal sql  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-sql
Achilleus Mantzios <achill@matrix.gatewaynet.com> wrote:

> For a) do all the necessary tuning on PostgreSQL.
> With 1GB of Mem, you could set a value of shared_buffers to 100000.

Perhaps just a type, but that is way to much! It would mean about 800 Mb
shared buffers! I would rather suggest a value between 1000 and 10000. See
recent descussions on -performance and -hackers mailing lists.

Best Regards,
Michael Paesold


pgsql-sql by date:

Previous
From: Ludwig Lim
Date:
Subject: Re: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
Next
From: Michael Hostbaek
Date:
Subject: Re: optimal sql