3 ms·

+1 I'd love to see a FreeBSD kernel hacker chime in here. ZFS enables some interesting things for pgsql: * http://open-zfs.org/wiki/Performance_tuning#Postgre

by kev009 13y ago

+1 I'd love to see a FreeBSD kernel hacker chime in here. ZFS enables some interesting things for pgsql: * http://open-zfs.org/wiki/Performance_tuning#PostgreSQL http://open-zfs.org/wiki/Performance_tuning#PostgreSQL - it seems like the primarycache setting prevents the double buffering problem that Linux' page cache has * http://citusdata.com/blog/64-zfs-compression http://citusdata.com/blog/64-zfs-compression I run pgsql on FreeBSD/ZFS and have no complaints but am not taxing the system.

ksec 13y ago
I love ZFS, but Oracle is holding it up which is very annoying.
- kev009 13y ago
  How do you mean? I trust OpenZFS more and in fact would consider it negligent if Oracle wasn't cherry picking OpenZFS bug fixes. Several original Sun engineers including ZFS co-founder Matt Ahrens are involved with OpenZFS.
  - bcantrill 13y ago
    Yes, as I have elaborated upon at length[1], the ZFS engineers have long-since left Oracle -- and the open community's ZFS (that is, OpenZFS) has become the ZFS of record. One clarification: Oracle can't actually cherry-pick back OpenZFS bug fixes because they are (ironically) violating the CDDL by not making available source code. This isn't an issue for the code for which they hold copyright -- but that doesn't include any of the bug fixes and features that we've seen in OpenZFS since 2010. And yes, it is absolutely negligent, but of a different sort than you intended... [1] http://www.youtube.com/watch?v=-zRN7XLCRhc http://www.youtube.com/watch?v=-zRN7XLCRhc
    - kev009 13y ago
      Cheers Bryan, that's a great one of your talks and thanks for the interesting licensing comedy.
- octotoad 13y ago
  Do you mean they're holding back progress? With OpenZFS on the scene, it's highly likely that the original Sun/Oracle implementation will become irrelevant to everyone apart from users of Oracle's Solaris releases.
sickpig 13y ago
other useful resources on using PostgresSQL on a Linux server with a ZFS filesystem: - http://adpgtech.blogspot.it/2013/04/linuxzfs-is-great.html http://adpgtech.blogspot.it/2013/04/linuxzfs-is-great.html - http://wiki.postgresql.org/images/8/86/PostgreSQL_on_ZFS.pdf http://wiki.postgresql.org/images/8/86/PostgreSQL_on_ZFS.pdf - http://lanyrd.com/2013/linuxcon-north-america/scqmfb/ http://lanyrd.com/2013/linuxcon-north-america/scqmfb/ - http://www.postgresql.org/message-id/CAGa5y0NkVLTNGywmZ6YS8O+2u8Z1aH-tv8kEXgBpOLFNhzy7FQ@mail.gmail.com http://www.postgresql.org/message-id/CAGa5y0NkVLTNGywmZ6YS8O...

by kev009 13y ago

ksec 13y ago

I love ZFS, but Oracle is holding it up which is very annoying.

kev009 13y ago
How do you mean? I trust OpenZFS more and in fact would consider it negligent if Oracle wasn't cherry picking OpenZFS bug fixes. Several original Sun engineers including ZFS co-founder Matt Ahrens are involved with OpenZFS.
- bcantrill 13y ago
  Yes, as I have elaborated upon at length[1], the ZFS engineers have long-since left Oracle -- and the open community's ZFS (that is, OpenZFS) has become the ZFS of record. One clarification: Oracle can't actually cherry-pick back OpenZFS bug fixes because they are (ironically) violating the CDDL by not making available source code. This isn't an issue for the code for which they hold copyright -- but that doesn't include any of the bug fixes and features that we've seen in OpenZFS since 2010. And yes, it is absolutely negligent, but of a different sort than you intended... [1] http://www.youtube.com/watch?v=-zRN7XLCRhc http://www.youtube.com/watch?v=-zRN7XLCRhc
  - kev009 13y ago
    Cheers Bryan, that's a great one of your talks and thanks for the interesting licensing comedy.
octotoad 13y ago
Do you mean they're holding back progress? With OpenZFS on the scene, it's highly likely that the original Sun/Oracle implementation will become irrelevant to everyone apart from users of Oracle's Solaris releases.

sickpig 13y ago

other useful resources on using PostgresSQL on a Linux server with a ZFS filesystem: - http://adpgtech.blogspot.it/2013/04/linuxzfs-is-great.html http://adpgtech.blogspot.it/2013/04/linuxzfs-is-great.html - http://wiki.postgresql.org/images/8/86/PostgreSQL_on_ZFS.pdf http://wiki.postgresql.org/images/8/86/PostgreSQL_on_ZFS.pdf - http://lanyrd.com/2013/linuxcon-north-america/scqmfb/ http://lanyrd.com/2013/linuxcon-north-america/scqmfb/ - http://www.postgresql.org/message-id/CAGa5y0NkVLTNGywmZ6YS8O+2u8Z1aH-tv8kEXgBpOLFNhzy7FQ@mail.gmail.com http://www.postgresql.org/message-id/CAGa5y0NkVLTNGywmZ6YS8O...