pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kishore B <kishorebh@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Help needed to set the Optimal Value for shared_buffers.
Date: Sat, 2 Jul 2005 17:31:58 +0530
Message-ID: <42567e0605070205019007657@mail.gmail.com> (raw)

Hi, 
  I have a couple of issues.  
  One is regarding a file called 'fsync' and the other is related to
the sharedBuffers issue.

  1)  I am new to administering postgresql. When I was wandering
through the configuration files for the PostgreSQL, I observed the
'fsync' file. This file is almost identical to the postgresql.conf
file, but with differing values for parameters and some new / deleted
parameters when compared with the postgresql.conf file. What is the
file for?  Does it have any specific importance to be taken care of?

 2)  What is the optimall value for shared_buffers parameter to be set
for a huge database that contains a table with upto '4GB' data. We
have a dedicated server with 2GB RAM. The maximum connections that can
be made to the server is around 500. I found a lot of variation
between opinions of different people on this value. I also observed
that the said optimal values vary greatly with the version. For
PostgreSQL7.X, some suggested an optimal value of 32MB RAM and for
PostgreSQL8.0 some suggested a range of 32MB - 480MB. We are using
PostgreSQL7.x.

 Any help will be highly appreciated. 

Regards, 
Kishore.



view thread (2+ messages)  latest in thread

Message-ID: <42567e0605070205019007657@mail.gmail.com>
Permalink:  ../42567e0605070205019007657@mail.gmail.com/
Also on:    postgresql.org/message-id/42567e0605070205019007657@mail.gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kishorebh@gmail.com
  Subject: Re: Help needed to set the Optimal Value for shared_buffers.
  In-Reply-To: <42567e0605070205019007657@mail.gmail.com>
  References: <42567e0605070205019007657@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox