Re: [PERFORM] Performance of Perc 5i

2006-12-01 Thread Bucky Jordan
>Does anyone have any performance experience with the Dell Perc 5i controllers in >RAID 10/RAID 5? Check the archives for details- I posted some numbers a while ago. I was getting around 250 MB/s sequential write (dd) on Raid5x6, and about 220 MB/s on Raid 10x4 (keep in mind that's dd- RAID10 sh

[PERFORM] Performance of Perc 5i

2006-12-01 Thread Alex Turner
Does anyone have any performance experience with the Dell Perc 5i controllers in RAID 10/RAID 5? Thanks, Alex

Re: RES: [PERFORM] Bad iostat numbers

2006-12-01 Thread David Boreham
Carlos H. Reimer wrote: I´ve taken a look in the /var/log/messages and found some temperature messages about the disk drives: Nov 30 11:08:07 totall smartd[1620]: Device: /dev/sda, Temperature changed 2 Celsius to 51 Celsius since last report Can this temperature influence in the performance?

Re: [PERFORM] NAMEDATALEN and performance

2006-12-01 Thread Tom Lane
Alessandro Baretta <[EMAIL PROTECTED]> writes: > ... I would like to receive some > insight on the implications of such a choice. Beside the fact that the parser > has more work to do to decipher queries and whatnot, what other parts of the > server would be stressed by a verbose naming scheme?

RES: [PERFORM] Bad iostat numbers

2006-12-01 Thread Carlos H. Reimer
Hi, If you look the iostat data it shows that the system is doing much more writes than reads. It is strange, because if you look in the pg_stat tables we see a complete different scenario. Much more reads than writes. I was monitoring the presence of temporary files in the data directory what cou

RES: [PERFORM] Bad iostat numbers

2006-12-01 Thread Carlos H. Reimer
Hi, I´ve taken a look in the /var/log/messages and found some temperature messages about the disk drives: Nov 30 11:08:07 totall smartd[1620]: Device: /dev/sda, Temperature changed 2 Celsius to 51 Celsius since last report Can this temperature influence in the performance? Reimer > -Mensag

Re: [PERFORM] Defining performance.

2006-12-01 Thread Heikki Linnakangas
Paul Lathrop wrote: We run 4 ~25-30Gb databases which cache information from eBay. These databases have had performance issues since before I joined the company. The databases have gone through a number of iterations. Initially, they were deployed as one huge database - performance was apparently

Re: [PERFORM] NAMEDATALEN and performance

2006-12-01 Thread Alessandro Baretta
Tom Lane wrote: Alessandro Baretta <[EMAIL PROTECTED]> writes: I am considering the possibility of rebuilding the server with NAMEDATALEN equal to 256. I have seen an interesting thread [1] about the performance impact of raising NAMEDATALEN, but it did not seem conclusive. More to the point,