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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings