Re: [PERFORM] [HACKERS] 8.3beta1 testing on Solaris

2007-11-15 Thread Bruce Momjian
This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Jignesh K. Shah wrote: > > I changed CLOG Buffers to 16 > > Running the test again: > # ./read.d > dtrace: script

Re: [PERFORM] dell versus hp

2007-11-15 Thread Alan Hodgson
On Wednesday 14 November 2007, Jeff Frost <[EMAIL PROTECTED]> wrote: > > OK, impressive RAID-6 performance (not so impressive RAID-10 > > performance, but that could be a filesystem issue). Note to self; try > > an Areca controller in next storage server. > > I believe these were both on ext3. I

Re: [PERFORM] dell versus hp

2007-11-15 Thread Vivek Khera
On Nov 14, 2007, at 5:36 PM, Jeff Frost wrote: I believe these were both on ext3. I thought I had some XFS results available for comparison, but I couldn't find them. You'd see similar with the UFS2 file system on FreeBSD. ---(end of broadcast)---

Re: [PERFORM] Curious about dead rows.

2007-11-15 Thread Erik Jones
On Nov 14, 2007, at 4:46 PM, Tom Lane wrote: Russell Smith <[EMAIL PROTECTED]> writes: It is possible that analyze is not getting the number of dead rows right? Hah, I think you are on to something. ANALYZE is telling the truth about how many "dead" rows it saw, but its notion of "dead" is

Re: [PERFORM] dell versus hp

2007-11-15 Thread Jeff Trout
On Nov 14, 2007, at 9:19 PM, Jeff Frost wrote: On an 8xRAID10 volume with the smaller Areca controller we were seeing around 450 seeks/sec. On our 6 disk raid10 on a 3ware 9550sx I'm able to get about 120 seek + reads/sec per process, with an aggregate up to about 500 or so. The dis