Increased storage size of jsonb in pg15

From: Sean Flaherty <sflaherty(at)grndwork(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Increased storage size of jsonb in pg15
Date: 2023-12-13 22:07:58
Message-ID: CAOscTZMM5QvuXLUN5yE90w=dM+X=6saJR_1ABiOTtt+Y9G3KnQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

We are seeing an increase in the reported storage size of our jsonb columns
(using pg_column_size) since upgrading to Postgres 15.5 from version 14.
The increase in size is enough to push us over the size threshold and more
of our data to get written to the TOAST table.

I can't find any information online, is anyone aware of what would cause
this change in storage size for essentially the same data?

Kind regards,
Sean

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-12-13 22:21:39 Re: Increased storage size of jsonb in pg15
Previous Message Adrian Klaver 2023-12-13 17:29:35 Re: how can I fix my accent issues?