Re: kernel version impact on PostgreSQL performance

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: kernel version impact on PostgreSQL performance
Дата
Msg-id 4B95F6F8.7030906@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: kernel version impact on PostgreSQL performance  ("Albe Laurenz" <laurenz.albe@wien.gv.at>)
Список pgsql-general
Albe Laurenz wrote:
> Maybe that question is dumb, but why should a change in ext4 have an
> impact on a figure that was generated with ext3? To quote the link:
>
> "the PostgreSQL performance atop the EXT3 file-system has fallen off a cliff"
>

What I'm guessing is that after finding the root problem because it's
more obvious when combined with ext4, someone has now put the fix for it
in the right place for 2.6.33 so that it also impacts ext3 writes.  That
would be more good news from a reliability perspective, and bad news
from an advocacy one because it looks really bad on benchmarks if the
writer doesn't understand how database commits to disk work--which seems
to the case at Phoronix.  They really are not running the right sort of
PostgreSQL benchmarks at all over there.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: [NOVICE] How to read oracle table's data from postgre
Следующее
От: John R Pierce
Дата:
Сообщение: Re: kernel version impact on PostgreSQL performance