Re: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?

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
>