Perfomance Tuning

From: mixo <mixo(at)coza(dot)net(dot)za>
To: pgsql-performance(at)postgresql(dot)org
Subject: Perfomance Tuning
Date: 2003-08-08 10:28:09
Message-ID: 3F337B39.5030904@coza.net.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bjoern Metzdorf 2003-08-08 10:40:13 Re: Perfomance Tuning
Previous Message Yaroslav Mazurak 2003-08-08 07:53:57 Re: PostgreSQL performance problem -> tuning