Re: Need help with 8.4 Performance Testing

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Need help with 8.4 Performance Testing
Дата
Msg-id 603c8f070812091458w14021741s61996a27e94f1c82@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Need help with 8.4 Performance Testing  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Need help with 8.4 Performance Testing  (Ben Chobot <bench@silentmedia.com>)
Re: Need help with 8.4 Performance Testing  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
> Hmm ... I wonder whether this means that the current work on
> parallelizing I/O (the posix_fadvise patch in particular) is a dead
> end.  Because what that is basically going to do is expend more CPU
> to improve I/O efficiency.  If you believe this thesis then that's
> not the road we want to go down.

I don't believe the thesis.  The gap between disk speeds and memory
speeds may narrow over time, but I doubt it's likely to disappear
altogether any time soon, and certainly not for all users.

Besides which, I believe the CPU overhead of that patch is pretty darn
small when the feature is not enabled.

...Robert

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

Предыдущее
От: "David Wilson"
Дата:
Сообщение: Re: query plan with index having a btrim is different for strings of different length
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Need help with 8.4 Performance Testing