Re: pgbench results arent accurate

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: pgbench results arent accurate
Дата
Msg-id CAHyXU0w+WG8=s5zsTmC=azp59MtEgjGeArkTHEMcp3RwoJX4TA@mail.gmail.com
обсуждение исходный текст
Ответ на pgbench results arent accurate  (Mariel Cherkassky <mariel.cherkassky@gmail.com>)
Список pgsql-performance
On Wed, Dec 12, 2018 at 6:54 AM Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
Hey,
I installed a new postgres 9.6 on both of my machines. I'm trying to measure the differences between the performances in each machine but it seems that the results arent accurate.
I did 2 tests : 

Better phrased, I'd say the results aren't _stable_ -- 'inaccurate' suggests that pgbench is giving erroneous results; you've provided no evidence of that.

Storage performance can seem random; there are numerous complex processes and caching that are involved between the software layer and the storage.  Some are within the database, some are within the underlying operating system, and some are within the storage itself.  Spinning media is also notoriously capricious, various hard to control for factors (such as where the data precisely exists on the platter) can influence data seek and fetch times.

I think we can look ahead to a not too distant future where storage performance will be less important with regards to typical database performance than it is today.  Clever people that are willing and able to buy appropriate hardware already live in this world essentially, but the enterprise storage industry seems strongly inclined to postpone this day of reckoning as long as possible for obviously selfish reasons.


merlin

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

Предыдущее
От: Rick Otten
Дата:
Сообщение: Re: Why Postgres doesn't use TID scan?
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: database crash during pgbench run