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

Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?

Thanks,

Edson

-----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?

No personal experience, but someone recently pointed out this article
to me:

"Btrfs considered … helpful"

http://no0p.github.io/postgresql/2014/09/06/benchmarking-postgresql-btrfs-zlib.html

Joe

- --
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBAgAGBQJUFImdAAoJEDfy90M199hlvocQAJLgkZ9wppb/FjXPgZs5aWKZ
4DSm/V1CxcVLOjf4TdmnrbUPugu6wR1da03wvfrLSaLmk7mte45X2kLh4KFZ6I2T
LMo1EoJwkQWS7a0/wNkPjeWmdG1UMbVTEhCSEC1MF/8LTOjd+2EXGvZM84msyUc5
PanWJvddJouoqNTdhHUigEifkDhjsbvB/xewVPmXhEwqMahnRXG8emO1H7D+uCz9
1kZqX8NdWJlTPh5a42ZIE5JflymQ5MFWt3V42SEy1AxK5ooBTkIafgMhJTfIssB4
yl6X2AwTQnuSZh0Rpea8f+uhSyOGlErdhbkgXQRpPyXF6PN19nHSFSfYDF4xQCfA
fBHznprz4yL0Olbo/5u7/wjMV1dlN8ZNsZD/bMTSbR/B1FRvCxT1k9LAaTDdqXqb
m+NvD6RY78A8T4iaFpfSU3Kits+WN9+q8iqAQI20mi2ECC+2FaDQxzDYQ8hWt5rR
A7D/9LzOZvPvVN2teVEmrP2vhbOBFyV+bpAGR4v3l5MhIOMoyv4QaWD9ol1sktw/
0qRB9iDecGwt8zPqhssireVrN4KfkGLcRQytlyl/sjyyiYq2sP4JNfKQQMby2mWc
2BjWxUZKrgv+dKulSj7uMhIsxXf3kH6VeHmk43rQ1wg9geb1oW3oTsffwxhRJR7F
Nc1qLPqaCU7KMiJY32TE
=xmyh
-----END PGP SIGNATURE-----

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

--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, @cmdpromptinc
"If we send our children to Caesar for their education, we should
              not be surprised when they come back as Romans."

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
>