From: Bjoern Metzdorf <bm@turtle-entertainment.de>
To: mixo <mixo@coza.net.za>
To: pgsql-performance@postgresql.org
Subject: Re: Perfomance Tuning
Date: Fri, 8 Aug 2003 12:40:13 +0200
Message-ID: <01ed01c35d99$73f08d70$0564a8c0@shock> (raw)
References: <3F337B39.5030904@coza.net.za>
> 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.
For 15 users you won't need great tuning at all. Just make sure, that you
have the right indizes on the tables and that you have good queries (query
plan).
About the 8Meg blobs, I don't know. Other people on this list may be able to
give you hints here.
Regards,
Bjoern
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: bm@turtle-entertainment.de, mixo@coza.net.za
Subject: Re: Perfomance Tuning
In-Reply-To: <01ed01c35d99$73f08d70$0564a8c0@shock>
References: <3F337B39.5030904@coza.net.za> <01ed01c35d99$73f08d70$0564a8c0@shock>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox