Re: Script to compute random page cost

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Script to compute random page cost
Дата
Msg-id 19140.1031666449@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Script to compute random page cost  (Curt Sampson <cjs@cynic.net>)
Ответы Re: Script to compute random page cost  (Curt Sampson <cjs@cynic.net>)
Список pgsql-hackers
Curt Sampson <cjs@cynic.net> writes:
> Well, for the sequential reads, the readahead should be trigerred
> even when reading from a raw device.

That strikes me as an unportable assumption.

Even if true, we can't provide a test mechanism that requires root
access to run it --- raw-device testing is out of the question just on
that basis, never mind that it is not measuring what we want to measure.

Perhaps it's time to remind people that what we want to measure
is the performance seen by a C program issuing write() and read()
commands, transferring 8K at a time, on a regular Unix filesystem.
A shell script invoking dd is by definition going to see a very
different performance ratio, even if what dd does under the hood
is 8K read() and write() (another not-well-supported assumption,
IMHO).  If you try to "improve" the results by using a raw device,
you're merely moving even further away from the scenario of interest.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: problem with new autocommit config parameter and jdbc
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Optimization levels when compiling PostgreSQL...