Preallocation changes in Postgresql 16

From: Riku Iki <riku(dot)iki(dot)x(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Preallocation changes in Postgresql 16
Date: 2024-04-25 01:44:47
Message-ID: CAMazQQfp+3f8tD_Q23rCR=O+Jj4jouSRVigbD8OmrTOfHV+8gA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 "compsize" tool, I indeed see that PostgreSQL preallocating
data and it is not compressed (there is separate "preallocated" entry in
output).

I am wondering if there were preallocation related changes in PG16, and if
it is possible to disable preallocation in PostgreSQL 16?

I posted
<https://dba.stackexchange.com/questions/338906/preallocation-changes-in-postgresql-16>
this on StackExchange, and someone pointed on this commit
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=00d1e02be24987180115e371abaeb84738257ae2>
as possible reason of such behavior.

Long discussion
<https://lore.kernel.org/all/6ae85272-3967-417e-bc9a-e2141a4c688a(at)gmx(dot)com/T/>
on
lore.kernel.org about exactly this issue.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kashif Zeeshan 2024-04-25 07:46:29 Re: What linux version to install ?
Previous Message Celia McInnis 2024-04-24 22:05:12 Re: is there an immutable function to switch from date to character?