Is LZ4 compression of the ZFS L2ARC available in any RELEASE/STABLE?

[Bob Friesenhahn]

On Tue, 4 Mar 2014, Olav Gjerde wrote:

> I managed to mess up who I replied to and Matthew replied back with a good
> answer which I think didn't reach the mailing list.
>
> I actually have a problem with query performance in one of my databases
> related to running PostgreSQL on ZFS. Which is why I'm so interested in
> compression for the L2ARC Cache. The problem is random IO read were
> creating a report were I aggregate 75000 rows takes 30 minutes!!! The table
> that I query has 400 million rows though.
> The dataset easily fit in memory, so if I run the same query again it takes
> less than a second.

Make sure that your database is on a filesystem with zfs block-size 
matching the database block-size (rather than 128K).  Otherwise far 
more data may be read than needed, and likewise, writes may result in 
writing far more data than needed.

Regardless, L2ARC on SSD is a very good idea for this case.

Bob
-- 
Bob Friesenhahn
bfriesen at simple.dallas.tx.us, http://www.simplesystems.org/users/bfriesen/
GraphicsMagick Maintainer,    http://www.GraphicsMagick.org/