Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?

[Edson Carlos Ericksson Richter]

Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?

Thanks,

Edson

[Joe Conway]

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

Post by Edson Carlos Ericksson Richter
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-----

[Joshua D. Drake]

Post by Joe Conway
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Post by Edson Carlos Ericksson Richter
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."

[Edson Carlos Ericksson Richter]

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

Post by Joshua D. Drake

Post by Joe Conway
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Post by Edson Carlos Ericksson Richter
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