Postgres Pro
Downloads
Home   >   mailing lists

Re: Shared buffers - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Shared buffers
Date
Msg-id bf54be870607271400q2cdb96d5me425f801c4c58285@mail.gmail.com
Whole thread Raw
In response to Shared buffers  ("Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de>)
Responses Re: Shared buffers  (Jim Nasby <jnasby@pervasive.com>)
List pgsql-general
Tree view
Go to http://www.powerpostgresql.com/PerfList/ and see the shared_buffers settings section there.

Thanks,
--
Shoaib Mir
EnterpriseDB ( www.enterprisedb.com)


On 7/27/06, Christian Rengstl <Christian.Rengstl@klinik.uni-regensburg.de > wrote:
Hi list,

just wanted to ask what is a "good/reasonable" value for the shared_bufferes variable. Right now i set it to 64000 on a windows 2003 server with 1GB ram and 3.2 GHz which runs as file server (for only a small number of users) and db server.

Thanks

--
Christian Rengstl M.A.
Klinik und Poliklinik für Innere Medizin II
Kardiologie - Forschung
Universitätsklinikum Regensburg
B3 1.388
Franz-Josef-Strauss-Allee 11
93053 Regensburg
Tel.: +49-941-944-7230


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster




pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Can't start PostgreSQL
Next
From: David Gagnon
Date:
Subject: Re: PostgreSQL theoretical maximums.