| From: | Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk> |
|---|---|
| To: | mixo <mixo(at)coza(dot)net(dot)za> |
| Cc: | "pgsql-performance (at) postgresql (dot) org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Perfomance Tuning |
| Date: | 2003-08-08 11:28:00 |
| Message-ID: | 20030808122800.A10464@bacon |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 08/08/2003 11:28 mixo wrote:
> I have just installed redhat linux 9 which ships with Pg
> 7.3.2. Pg has to be setup so that data inserts (blobs) should
> be able to handle at least 8M at a time. The machine has
> two P III 933MHz CPU's, 1.128G RAM (512M*2 + 128M), and
> a 36 Gig hd with 1 Gig swap and 3 equal size ext3 partitions.
> What would be the recomended setup for good performance
> considering that the db will have about 15 users for
> 9 hours in a day, and about 10 or so users throughout the day
> who wont be conistenly using the db.
It doesn't sound like a particlarly heavy loading to me. I'd start off
with something like
shared_buffers = 2000
sort_mem = 1024
max_coonections = 100
and see how it performs under normal business loading.
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-08-08 13:28:13 | Re: Perfomance Tuning |
| Previous Message | Shridhar Daithankar | 2003-08-08 10:52:52 | Re: Perfomance Tuning |