I did the testing and confirmed that this was the issue.
I run following query:
create table t as select '1234567890' from generate_series(1, 10);
I commented if (numblocks > 8) codeblock, and see the following results
from "compsize /dbdir/" command.
Before my changes:
Processed
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 if there
On Fri, Apr 26, 2024 at 4:37 AM Riku Iki wrote:
> I am wondering if there were preallocation related changes in PG16, and if it
> is possible to disable preallocation in PostgreSQL 16?
I have no opinion on the btrfs details, but I was wondering if someone
might show up with a system that
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 b
