pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Help needed to set the Optimal Value for shared_buffers. 2+ messages / 2 participants [nested] [flat]
* Help needed to set the Optimal Value for shared_buffers. @ 2005-07-02 12:01 Kishore B <kishorebh@gmail.com> 2005-07-02 13:52 ` Re: Help needed to set the Optimal Value for shared_buffers. Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Kishore B @ 2005-07-02 12:01 UTC (permalink / raw) To: pgsql-admin 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. ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Help needed to set the Optimal Value for shared_buffers. 2005-07-02 12:01 Help needed to set the Optimal Value for shared_buffers. Kishore B <kishorebh@gmail.com> @ 2005-07-02 13:52 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2005-07-02 13:52 UTC (permalink / raw) To: Kishore B <kishorebh@gmail.com>; +Cc: pgsql-admin Kishore B <kishorebh@gmail.com> writes: > 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? There is no such file in any standard distribution of Postgres. I guess that some previous admin of your machine made it as a copy of one set of config parameters that he was experimenting with. > 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. Opinions vary, but I would say that 10000-50000 buffers is a reasonable range to be working in. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-07-02 13:52 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-07-02 12:01 Help needed to set the Optimal Value for shared_buffers. Kishore B <kishorebh@gmail.com> 2005-07-02 13:52 ` Tom Lane <tgl@sss.pgh.pa.us>
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