Re: strange performance regression between 7.4 and 8.1
От | Alex Deucher |
---|---|
Тема | Re: strange performance regression between 7.4 and 8.1 |
Дата | |
Msg-id | a728f9f90703011916x17f40884qdb90dd21946154d4@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: strange performance regression between 7.4 and 8.1 ("Joshua D. Drake" <jd@commandprompt.com>) |
Список | pgsql-performance |
On 3/1/07, Joshua D. Drake <jd@commandprompt.com> wrote: > Alex Deucher wrote: > > On 3/1/07, Joshua D. Drake <jd@commandprompt.com> wrote: > >> \ > >> >> Is the SAN being shared between the database servers and other > >> >> servers? Maybe > >> >> it was just random timing that gave you the poor write performance on > >> >> the old > >> >> server which might be also yielding occassional poor performance on > >> >> the new > >> >> one. > >> >> > >> > > >> > The direct attached scsi discs on the old database server we getting > >> > 45MBps not the SAN. The SAN got 62/145Mbps, which is not as bad. > >> > >> How many spindles you got in that SAN? > > > > 105 IIRC. > > You have 105 spindles are you are only get 62megs on writes? That seems > about half what you should be getting. (at least). > Take the numbers with grain of salt. They are by no means a thorough evaluation. I just ran bonnie a couple times to get a rough reference point. I can do a more thorough analysis. Alex > Joshua D. Drake > > > > > > Alex > > >
В списке pgsql-performance по дате отправления: