From: | "Graeme B(dot) Bell" <graeme(dot)bell(at)nibio(dot)no> |
---|---|
To: | Bram Van Steenlandt <bram(at)diomedia(dot)be> |
Cc: | "pgsql-performance(at)postgresql(dot)org list" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: large object write performance |
Date: | 2015-10-08 11:21:50 |
Message-ID: | 465F0A34-AE24-457A-8B3E-60440862D7EF@skogoglandskap.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
>> First the database was on a partition where compression was enabled, I changed it to an uncompressed one to see if it makes a difference thinking maybe the cpu couldn't handle the load.
> It made little difference in my case.
>
> My regular gmirror partition seems faster:
> dd bs=8k count=25600 if=/dev/zero of=./test
> 25600+0 records in
> 25600+0 records out
> 209715200 bytes transferred in 1.513112 secs (138598612 bytes/sec)
>
> the zfs compressed partition also goes faster:
> dd bs=8k count=25600 if=/dev/zero of=./test
> 25600+0 records in
> 25600+0 records out
> 209715200 bytes transferred in 0.979065 secs (214199479 bytes/sec)
> but this one didn't really go that fast in my test (maybe 10%)
Please can you run iozone and look for low random write performance with small blocks? (4k)
http://www.slashroot.in/linux-file-system-read-write-performance-test
Also please can you CC to the list with your replies to my on-list emails?
Graeme Bell
From | Date | Subject | |
---|---|---|---|
Next Message | Bram Van Steenlandt | 2015-10-08 11:33:22 | Re: large object write performance |
Previous Message | Graeme B. Bell | 2015-10-08 10:25:02 | Re: large object write performance |