Is LZ4 compression of the ZFS L2ARC available in any RELEASE/STABLE?
Bob Friesenhahn
bfriesen at simple.dallas.tx.us
Wed Mar 5 02:42:36 UTC 2014
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/
More information about the freebsd-fs
mailing list