From: | "Anjan Dave" <adave(at)vantage(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Tuning for mid-size server |
Date: | 2003-10-21 14:28:13 |
Message-ID: | 2F2E24372F10744588A27DEECC85FE04B6769C@vt-pe2550-001.vantage.vantage.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hi,
Pretty soon, a PowerEdge 6650 with 4 x 2Ghz XEONs, and 8GB Memory, with
internal drives on RAID5 will be delivered. Postgres will be from RH8.0.
I am planning for these values for the postgres configuration - to begin
with:
Shared_buffers (25% of RAM / 8KB)) = 8589934592 * .25 / 8192 = 262144
Sort_mem (4% of RAM / 1KB) = 335544. We'll take about half of that -
167772
Effective_cache_size = 262144 (same as shared_buffers - 25%)
In the /etc/sysctl file:
=================
kernel.shmall = 536870912 (512MB) SHMALL Total amount of shared memory
available (bytes or pages)
kernel.shmmax = 536870912 (512MB) SHMMAX Maximum size of shared memory
segment (bytes)
In a generic sense, these are recommended values I found in some
documents. The database will be small in size and will gradually grow
over time from few thousands to a few million records, or more. The
activity will be mostly of select statements from a few tables with
joins, orderby, groupby clauses. The web application is based on
Apache/Resin and hotspot JVM 1.4.0.
Are the above settings ok to begin with? Are there any other parameters
that I should configure now, or monitor lateron?
In other words, am I missing anything here to take full advantage of 4
CPUs and 8Gigs of RAM?
Appreciate any help.
Thanks,
Anjan
************************************************************************
**
This e-mail and any files transmitted with it are intended for the use
of the addressee(s) only and may be confidential and covered by the
attorney/client and other privileges. If you received this e-mail in
error, please notify the sender; do not disclose, copy, distribute, or
take any action in reliance on the contents of this information; and
delete it from your system. Any other use of this e-mail is prohibited.
From | Date | Subject | |
---|---|---|---|
Next Message | Harry Broomhall | 2003-10-21 14:50:48 | Re: Performance weirdness with/without vacuum analyze |
Previous Message | Geoffrey | 2003-10-21 13:39:52 | Re: PostgreSQL data on a NAS device ? |