Re: Perfomance Tuning - Mailing list pgsql-performance

From mixo
Subject Re: Perfomance Tuning
Date
Msg-id 3F389449.8050305@coza.net.za
Whole thread Raw
In response to Re: Perfomance Tuning  ("Bjoern Metzdorf" <bm@turtle-entertainment.de>)
Responses Re: Perfomance Tuning
List pgsql-performance
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
>
>



pgsql-performance by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Perfomance Tuning
Next
From: Bruce Momjian
Date:
Subject: Re: Perfomance Tuning