21 maj 2014 kl. 22:05 skrev Sean Chittenden :
I did some tests with zfs, and results where appallingly bad, but that was
with db size > ram.
>
> I think the model used by PostgreSQL, as most databases, are very disk
> block centric. Using zfs makes it hard to get good p
>>> I did some tests with zfs, and results where appallingly bad, but that was
>>> with db size > ram.
I think the model used by PostgreSQL, as most databases, are very disk
block centric. Using zfs makes it hard to get good performance. But this
was some time ago, maybe th
On 21/05/2014 18:17, Sean Chittenden wrote:
>> I did some tests with zfs, and results where appallingly bad, but that was
>> with db size > ram.
>> >
>> > I think the model used by PostgreSQL, as most databases, are very disk
>> > block centric. Using zfs makes it hard to get good performance.
> I did some tests with zfs, and results where appallingly bad, but that was
> with db size > ram.
>
> I think the model used by PostgreSQL, as most databases, are very disk block
> centric. Using zfs makes it hard to get good performance. But this was some
> time ago, maybe things have improv
I did some tests with zfs, and results where appallingly bad, but that was with
db size > ram.
I think the model used by PostgreSQL, as most databases, are very disk block
centric. Using zfs makes it hard to get good performance. But this was some
time ago, maybe things have improved.
Palle
Gotcha.
I've been testing using pgbench on FreeBSD 9.0 release + ZFS + pg 9.3.. I
can reach the freebsd 10 stats on the pdf files if the dataset RAM. Test was done on pools without L2ARC
and with/without compression. I also remember increasing a vm.pmap sysctl.
I'm out of the office right now sick
