Re: 8.3 / 8.2.6 restore comparison
От | Joshua D. Drake |
---|---|
Тема | Re: 8.3 / 8.2.6 restore comparison |
Дата | |
Msg-id | 20080207173904.7b974273@jd-laptop обсуждение исходный текст |
Ответ на | Re: 8.3 / 8.2.6 restore comparison ("Joshua D. Drake" <jd@commandprompt.com>) |
Ответы |
Re: 8.3 / 8.2.6 restore comparison
|
Список | pgsql-hackers |
On Thu, 7 Feb 2008 16:37:39 -0800 "Joshua D. Drake" <jd@commandprompt.com> wrote: > I didn't, but do now and am testing. The way this is currently > designed is: > > /data1 (8 disks RAID 10) > /data2 (8 disks RAID 10) > /pg_xlogs (2 disks RAID 1) > > /data1 is what is primarily written against for the first couple of > hours and then it will switch to data2 because of table spaces. > However either way, we should expect (I would think) to see at least > 100 megs a second on an 8 Disk RAID 10. It is SCSI. > Following up with this... 22G in one hour, with xlogs on a different partition. Just looking at we are averaging 3-5% IOWait, further we are only writing ~ 2Megs a second. This is frustrating. Sincerely, Joshua D. Drake -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit
В списке pgsql-hackers по дате отправления: