Re: What's the best hardver for PostgreSQL 8.1?

Поиск
Список
Период
Сортировка
От Markus Schaber
Тема Re: What's the best hardver for PostgreSQL 8.1?
Дата
Msg-id 43BD4CD5.8080207@logix-tt.com
обсуждение исходный текст
Ответ на Re: What's the best hardver for PostgreSQL 8.1?  (William Yu <wyu@talisys.com>)
Список pgsql-performance
Hi, William,

William Yu wrote:

> Random write performance (small block that only writes to 1 drive):
> 1 write requires N-1 reads + N writes --> 1/2N-1 %

This is not true. Most Raid-5 engines use XOR or similar checksum
methods. As opposed to cryptographic checksums, those can be updated and
corrected incrementally.

check_new = check_old xor data_old xor data_new

So 2 reads and 2 writes are enough: read data and checksum, then adjust
the checksum via the data difference, and write data and new checksum.

And often, the old data block still is in cache, accounting to 1 read
and two writes.

HTH,
Markus
--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

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

Предыдущее
От: "Andy"
Дата:
Сообщение: Improving Inner Join Performance
Следующее
От: Frank Wiles
Дата:
Сообщение: Re: Improving Inner Join Performance