| From: | Brad Rhine <brad(at)truetech(dot)org> |
|---|---|
| To: | PGSQL Novices <pgsql-novice(at)postgresql(dot)org> |
| Subject: | PGSQL Config |
| Date: | 2004-11-19 16:35:10 |
| Message-ID: | FADB6CAC-3A48-11D9-AC88-000D9336142C@truetech.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
I've developed a solution for my school that will use PostgreSQL as our
backend. I'm pleased with the performance, but so far we've only done
testing in small groups. We go live with the system fairly soon, but
I'm not terribly familiar with the postgresql.conf file. I was
wondering what advice you might have for my particular configuration.
I'll be running on a dual 2 GHz G5 XServe with 1 GB RAM. I could have
upwards of 300 people accessing the server at any given time, although
the load will usually be closer to 100. Most people will be creating
and updating records. I guess I'm wondering most about how high I
should set max_connections, shared_buffers, etc. They'll be using a
client application, not a web-based system. Thanks in advance for any
help you can provide.
--
brad(at)truetech(dot)org
http://truetech.org
<><e
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sarlav kumar | 2004-11-19 18:38:57 | another index scan problem |
| Previous Message | Tom Lane | 2004-11-19 16:20:14 | Re: user defined type |