Re: Benchmark with FreeBSD 8.0 and pgbench

From: Віталій Тимчишин <tivv00(at)gmail(dot)com>
To: "joao(dot)pinheiro" <joao(dot)pinheiro(at)pontosi(dot)pt>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Benchmark with FreeBSD 8.0 and pgbench
Date: 2010-05-17 07:06:25
Message-ID: AANLkTimjkwFSGv1_gT5kcWdkDKEC5W68SmfaQyO0QZ1G@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Piotr Legiecki 2010-05-17 08:06:23 Re: old server, new server, same performance
Previous Message Jayadevan M 2010-05-17 05:04:29 pg_dump and pg_restore