Re: Configuration Optimisation
От | Howard Cole |
---|---|
Тема | Re: Configuration Optimisation |
Дата | |
Msg-id | 4B4F4E67.8070700@selestial.com обсуждение исходный текст |
Ответ на | Re: Configuration Optimisation (Leif Biberg Kristensen <leif@solumslekt.org>) |
Список | pgsql-general |
Leif Biberg Kristensen wrote: > On Thursday 14. January 2010 16.55.07 Howard Cole wrote: > >> Leif Biberg Kristensen wrote: >> >>> On Thursday 14. January 2010 16.02.12 Andy Colson wrote: >>> >>> See my reply above. My 250 tps seems in line with the 700 tps on a modern >>> system that the OP gets on his Windows setup. To me it seems like >>> > something is > >>> broken on his Ubuntu setup. >>> >>> regards, >>> >>> >> I am hoping your assumptions are correct. I have reinstalled ubuntu from >> scratch as I had been tinkering with the power management on the server. >> Once the RAID has rebuilt, I shall try again. >> > > What kind of file system are you running? > > regards, > The file system is ext4. If I turn fsync off I get a TPS of 1120 so I think there is an issue with the speed of the array. The dd test give a speed of 125MB/s which seems reasonable to me. I can leave fsync off but I suspect that I am just ignoring the problem. Howard.
В списке pgsql-general по дате отправления: