From: mixo <mixo@coza.net.za>
To: Bjoern Metzdorf <bm@turtle-entertainment.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Perfomance Tuning
Date: Tue, 12 Aug 2003 09:16:25 +0200
Message-ID: <3F389449.8050305@coza.net.za> (raw)
In-Reply-To: <01ed01c35d99$73f08d70$0564a8c0@shock>
References: <3F337B39.5030904@coza.net.za>
<01ed01c35d99$73f08d70$0564a8c0@shock>
Thanks to everyone who responded. It's a pity that the discussion has gone
the ext2 vs ext3 route. The main reason I asked my original question is
that I am currently importing data into Pg which is about 2.9 Gigs.
Unfortunately, to maintain data intergrity, data is inserted into a table
one row at a time. This exercise took ~7 days on the same system with
slightly different setup(PIII 1.0GHZ, 512M RAM -- CPU speed was down graded
due to serveral over heating problems which have since been fixed, and RAM
was added for good measure). I have just reloaded the machine, and started
the import. So far ~ 6000 record have been imported, and there is 32000
left.
P.S. Importing the same data on Mysql took ~2 days.
Bjoern Metzdorf wrote:
>>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: mixo@coza.net.za, bm@turtle-entertainment.de
Subject: Re: Perfomance Tuning
In-Reply-To: <3F389449.8050305@coza.net.za>
References: <3F337B39.5030904@coza.net.za> <01ed01c35d99$73f08d70$0564a8c0@shock> <3F389449.8050305@coza.net.za>
* 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