From: | Edson Carlos Ericksson Richter <edsonrichter(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux? |
Date: | 2014-09-13 20:11:59 |
Message-ID: | BLU436-SMTP15EAFAFC211C6140283573CFCA0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Edson Carlos Ericksson Richter | 2014-09-13 22:44:44 | After upgrade from 9.2.9 to 9.3.5 got reduced contention |
Previous Message | Joshua D. Drake | 2014-09-13 19:32:05 | Re: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux? |