Re: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux? - Mailing list pgsql-general

From Edson Carlos Ericksson Richter
Subject Re: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?
Date
Msg-id BLU436-SMTP15EAFAFC211C6140283573CFCA0@phx.gbl
Whole thread Raw
In response to Re: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
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
>



pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?
Next
From: Edson Carlos Ericksson Richter
Date:
Subject: After upgrade from 9.2.9 to 9.3.5 got reduced contention