[PERFORM] Perfomance Tuning

2003-08-14 Thread mixo
I have just installed redhat linux 9 which ships with Pg 7.3.2. Pg has to be setup so that data inserts (blobs) should 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

Re: [PERFORM] Perfomance Tuning

2003-08-14 Thread mixo
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

[PERFORM] Benchmark

2003-08-15 Thread mixo
I have the following setup : Apache 2 + mod_perl 2 Postgres 7.3.2 I need to is measure the perfomance of a ticketing system (written in perl) which has web interface (html::mason, apache2) with Pg as a backend. Users of the ticketing system can only connect to the backend via the web interface a