Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?

2021-04-26 Thread Marc Millas
Interesting ! the debian blog saying that " but only users who are interested in debugging future bugs should use transparent compression at this time" makes me feel its less urgent to test this option... Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Mon, Apr 26, 2021 at 3:43 PM

Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?

2021-04-26 Thread Rory Campbell-Lange
On 26/04/21, Marc Millas (marc.mil...@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

Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13?

2021-04-26 Thread Marc Millas
Hi Bruce, everybody, 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,