Re: How to improve db performance with $7K?
От | Dave Cramer |
---|---|
Тема | Re: How to improve db performance with $7K? |
Дата | |
Msg-id | 424946C8.6020003@fastcrypt.com обсуждение исходный текст |
Ответ на | Re: How to improve db performance with $7K? (PFC <lists@boutiquenumerique.com>) |
Список | pgsql-performance |
Yeah, 35Mb per sec is slow for a raid controller, the 3ware mirrored is about 50Mb/sec, and striped is about 100 Dave PFC wrote: > >> With hardware tuning, I am sure we can do better than 35Mb per sec. Also > > > WTF ? > > My Laptop does 19 MB/s (reading <10 KB files, reiser4) ! > > A recent desktop 7200rpm IDE drive > # hdparm -t /dev/hdc1 > /dev/hdc1: > Timing buffered disk reads: 148 MB in 3.02 seconds = 49.01 MB/sec > > # ll "DragonBall 001.avi" > -r--r--r-- 1 peufeu users 218M mar 9 20:07 DragonBall > 001.avi > > # time cat "DragonBall 001.avi" >/dev/null > real 0m4.162s > user 0m0.020s > sys 0m0.510s > > (the file was not in the cache) > => about 52 MB/s (reiser3.6) > > So, you have a problem with your hardware... > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > >
В списке pgsql-performance по дате отправления: