Re: [PERFORM] Performance increase with elevator=deadline

2008-04-18 Thread Enrico Sirola
Hi, Il giorno 11/apr/08, alle ore 20:03, Craig Ringer ha scritto: Speaking of I/O performance with PostgreSQL, has anybody here done any testing to compare results with LVM to results with the same filesystem on a conventionally partitioned or raw volume? I'd probably use LVM even at a pe

Re: [PERFORM] Benchmark: Dell/Perc 6, 8 disk RAID 10

2008-03-17 Thread Enrico Sirola
Hi Justin, Il giorno 17/mar/08, alle ore 20:38, Justin ha scritto: it is a RAID 10 controller with 6 SAS 10K 73 gig drives.The server is 3 weeks old now. it has 16 gigs of RAM 2 quad core Xenon 1.88 Ghz processors 2 gig Ethernet cards. RAID controller perc 6/i with battery backup 512meg

Re: [PERFORM] 8.3 write performance

2008-03-14 Thread Enrico Sirola
Hi, I follow up myself: I was using pgbench with the wrong scale size. With the configuration I posted before and scale=100 I Get the following: sudo -u postgres pgbench -c 10 -t 1 -s 100 starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 10 n

[PERFORM] 8.3 write performance

2008-03-12 Thread Enrico Sirola
Hello, (you could receive this message twice - I have some email issues sorry) I'm setting up a new DB with Centos 5 (amd64) + postgresql 8.3 installed from the pgsql yum repository. This is a host dedicated to postgresql. From the benchmarks I found here and there on the web, and having digged