I do have a development machine using constrained SSD disk, and I would like to take advantage of compression.

But would not want to reformat everything on ZFS (I'm actually using Ext4).
Nevertheless, seems that Joe had a bad experience with Btrfs (my expectation was to just migrate from Ext4 to Btfrs and be able to take advantage of a brand new FS features).

Thanks, I'll play a little with both (using VM) and check if there is anything simpler.

Edson


On 13-09-2014 16:32, Joshua D. Drake wrote:

On 09/13/2014 11:14 AM, Joe Conway wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 09/13/2014 08:24 AM, Edson Carlos Ericksson Richter wrote:
Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on
Linux?

Yes. It ran great for over a month but once we had some serious data in it (multiple terrabytes) it died, more than once, and the last time was so bad it was unrecoverable. This was just this summer and yes we were using the latest.

We have found the ZFS on Linux is working quite nicely.

JD




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to