| From: | Jessica Richard <rjessil(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | best starting points.... |
| Date: | 2008-07-12 12:03:46 |
| Message-ID: | 202919.57936.qm@web56405.mail.re3.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On a new system with 64G memory, what is the best starting points for
shmmax on OS and shared_buffers for Postgres. All databases combined
are about 50G.
I want to evaluate this with the two following scenarios:
1. this machine is running only Postgres, no other applications
2. this machine has postgres plus some other things (such as web server, etc).
What are the dangers for shmmax and shared_buffers to be confiugred very big for each of the two scenarios?
In case #1, if shmmax = 63G and shared_buffers = 50G, can it speed up Postgres (loading almost all dbs into memeory)?
Thanks,
Jessica
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michelle Konzack | 2008-07-12 13:37:52 | How to setup tablespace and table partitioning in a template? |
| Previous Message | Simon Riggs | 2008-07-11 17:15:57 | Re: pitr standby on slave with skewed time |