Re: Subtly Bad Things Linux May Be Doing To PostgreSQL
by sickpig on Thursday April 03, 2014 @05:21AM
(#7521743)
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://wiki.postgresql.org/images/8/86/PostgreSQL_on_ZFS.pdf
- http://lanyrd.com/2013/linuxcon-north-america/scqmfb/
- http://www.postgresql.org/message-id/CAGa5y0NkVLTNGywmZ6YS8O...
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL
by ksec on Thursday April 03, 2014 @04:50AM
(#7521652)
I love ZFS, but Oracle is holding it up which is very annoying.
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL
by kev009 on Thursday April 03, 2014 @05:28AM
(#7521765)
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.
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL
by bcantrill on Thursday April 03, 2014 @06:06AM
(#7521871)
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...
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL
by kev009 on Thursday April 03, 2014 @06:22AM
(#7521915)
Cheers Bryan, that's a great one of your talks and thanks for the interesting licensing comedy.
Re: Subtly Bad Things Linux May Be Doing To PostgreSQL
by octotoad on Thursday April 03, 2014 @05:35AM
(#7521779)
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.
ZFS enables some interesting things for pgsql:
* 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
I run pgsql on FreeBSD/ZFS and have no complaints but am not taxing the system.