Re: Preallocation changes in Postgresql 16

2024-05-02 Thread Riku Iki
80K zstd 3% 1.4G 42G 42G It is clearly visible that files created with fallocate are not compressed, and disk usage is much larger. I am wondering if there is a way to have some feature request to have this parameter user configurable.. On Fri, Apr 26, 2024 at 4:15 PM Ri

Re: Preallocation changes in Postgresql 16

2024-04-28 Thread Riku Iki
Thank you, I have such a system. I think my task would be to compile PG from sources(need to learn this), and see how it works with and without that code block. On Thu, Apr 25, 2024 at 2:25 PM Thomas Munro wrote: > On Fri, Apr 26, 2024 at 4:37 AM Riku Iki wrote: > > I am wondering

Preallocation changes in Postgresql 16

2024-04-25 Thread Riku Iki
Hi, We have PostgreSQL server, which currently runs PostgreSQL 15 on compressed btrfs. I tried to migrate DB to PostgreSQL 16, and found that data is not being compressed for PostgreSQL 16 server. One of the possible reason why btrfs won't compress data is data preallocation. When running "comps