Re: Increased storage size of jsonb in pg15 - Mailing list pgsql-general

From David G. Johnston
Subject Re: Increased storage size of jsonb in pg15
Date
Msg-id CAKFQuwb7z+y8ZmmMuTC6Kt+USNRGx2WutHt8QmgAw+MSPXKQcA@mail.gmail.com
Whole thread Raw
In response to Re: Increased storage size of jsonb in pg15  (Sean Flaherty <sflaherty@grndwork.com>)
Responses Re: Increased storage size of jsonb in pg15  (Sean Flaherty <sflaherty@grndwork.com>)
List pgsql-general
On Thu, Dec 14, 2023 at 7:48 AM Sean Flaherty <sflaherty@grndwork.com> wrote:
We have a process that runs once an hour to read the .dat file in csv format then a node script using the pg package version "8.8.0" to create the json objects and insert the data records as jsonb data.  

None of the upload process changed during the underlying database upgrade.

Basic debugging requires the existence of a self-contained reproducer.  In this case ideally one that only uses psql and some static (already processed) data files, and that is known to produce the observed behaviors on non-RDS PostgreSQL.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Increased storage size of jsonb in pg15
Next
From: Francisco Olarte
Date:
Subject: Re: vacuumdb did not analyze all tables?=