pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>  
>





view thread (55+ messages)  latest in thread

Message-ID: <3F389449.8050305@coza.net.za>
Permalink:  ../3F389449.8050305@coza.net.za/
Also on:    postgresql.org/message-id/3F389449.8050305@coza.net.za

 · 

reply

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