On 26/04/21, Marc Millas (marc.millas@mokadb.com) wrote: > compression ? > > I am currently working on a project to move an oracle db to postgres. > The db is 15 TB. > with Oracle compression it does use 5 TB of disk space. > > If we cannot compress the whole thing, the project loses its economic base. > (added 10 TB for prod, 10TB for pre-prod, 10TB for testing dev, ...) > > we do test zfs, and we will give a try to btrfs.
I've been using btrfs with lzo compression for several years on my personal laptop and some non-critical backup systems with no trouble. (In fact btrfs has helped us recover from some disk failures really well.) While I run postgresql on my machine it is for light testing purposes so I wouldn't want to comment on its suitability for production.
