Re: Benchmark with FreeBSD 8.0 and pgbench

Поиск
Список
Период
Сортировка
От Віталій Тимчишин
Тема Re: Benchmark with FreeBSD 8.0 and pgbench
Дата
Msg-id AANLkTimjkwFSGv1_gT5kcWdkDKEC5W68SmfaQyO0QZ1G@mail.gmail.com
обсуждение исходный текст
Ответ на Benchmark with FreeBSD 8.0 and pgbench  ("joao.pinheiro" <joao.pinheiro@pontosi.pt>)
Список pgsql-performance
Hi.

Not strictly connected to your tests, but:
As of ZFS, we've had experience that it degrades over time after random updates because of files becoming non-linear and sequential reads becomes random.
Also there are Q about ZFS block size - setting it to 8K makes first problem worse, setting it to higher values means that 8K write will need a read to recreate the whole block in new place.

Best regards,
 Vitalii Tymchyshyn

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

Предыдущее
От: Jayadevan M
Дата:
Сообщение: pg_dump and pg_restore
Следующее
От: Piotr Legiecki
Дата:
Сообщение: Re: old server, new server, same performance