Re: Benchmark with FreeBSD 8.0 and pgbench - Mailing list pgsql-performance

From Віталій Тимчишин
Subject Re: Benchmark with FreeBSD 8.0 and pgbench
Date
Msg-id AANLkTimjkwFSGv1_gT5kcWdkDKEC5W68SmfaQyO0QZ1G@mail.gmail.com
Whole thread Raw
In response to Benchmark with FreeBSD 8.0 and pgbench  ("joao.pinheiro" <joao.pinheiro@pontosi.pt>)
List 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 by date:

Previous
From: Jayadevan M
Date:
Subject: pg_dump and pg_restore
Next
From: Piotr Legiecki
Date:
Subject: Re: old server, new server, same performance