News for hackers. Stuff that matters.
Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by imiric on Monday October 02, 2023 @04:38AM (#37735459)
This is neat, but I wouldn't trust BTRFS for any serious usage. I've read way too many data loss reports to make me stay away even for personal use.

Could this work on ZFS, or a layered FS like Aufs/OverlayFS?

Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by bantunes on Monday October 02, 2023 @04:45AM (#37735517)
I thought the only major issues with Btrfs were with RAID usage. I mean, some distros default to it out of the box, right?
Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by capableweb on Monday October 02, 2023 @05:34AM (#37735908)
Both openSUSE and Fedora defaults to BTRFS so not sure what parent is talking about, you won't have any data loss for the average/common use cases.
Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by sofixa on Monday October 02, 2023 @08:34AM (#37737279)
Depends on what you mean by "common/average use cases". Common for desktop use, so at most two disk parity? Yeah, that's probably fine. Common for server use, so something akin to RAID5/6? It's still recommended to stay away from it on BTRFS, which makes it a non-starter for any NAS or most other server uses.
Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by imiric on Monday October 02, 2023 @06:16AM (#37736209)
True, most issues are with RAID, but there are still many others listed here[1] that I wouldn't be comfortable with.

Perhaps I'm being overly cautious after years of not experiencing issues with ext4+LVM+LUKS. BTRFS always gave the impression of being in a perpetual state of instability, but maybe I should take another look at it.

[1]: https://wiki.debian.org/Btrfs#Status

Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by argulane on Monday October 02, 2023 @05:44AM (#37735988)
There is https://github.com/Photonios/pgcow that supports ZFS.

BTRFS is not that scary. Quota and RAID56 is broken but other features have been stable quite some time. Btrfs is used by default for few Linux distros and Facebook makes quite heavy use of it on their servers https://lwn.net/Articles/824855/

I have been running btrfs on all of my machines since 2016 as transparrent file compression helps a lot with keeping disk usage down.

Btrfs RAID1 even saved my data once when one of the SSD's decided to die suddenly.

For maximum performance you should run databases on top of XFS anyway. It also supports per-file COW via reflinks.

Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by psi on Monday October 02, 2023 @09:44AM (#37738008)
No reason it couldn’t. I gave a micro-talk at RubyConf 2013 on a proof-of-concept I’d been experimenting with at work that used ZFS + git hooks to do pretty much the same thing.

https://m.youtube.com/watch?v=K66r3yZd2_I

Re:Pg_branch: Pre-alpha Postgres extension brings Neon-like ... by psi on Monday October 02, 2023 @05:51PM (#37744957)
Err, at GoRuCo, rather. The Gotham Ruby Conference :)