Re: Increased storage size of jsonb in pg15

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
<https://github.com/brianc/node-postgres> 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.

On Wed, Dec 13, 2023 at 4:56 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 12/13/23 15:49, Sean Flaherty wrote:
> > More information needed:
> >
>
> > 2) An example of reported size for the 14.? and 15.5 cases.
> >
> > Since upgrading from 14.8 to 15.5, the jsonb data that was previously
> > written in 14.8 is reporting a smaller size than the same hourly data
> > written after the upgrade (upgrade indicated in yellow):
>
> What is producing datafile.dat and how?
>
> >
> > *file* *hourly_timestamp* *filename_bytes*
> *timestamp_bytes*
> > *data_filesize* *created_at_bytes* *updated_at_bytes*
> > datafile.dat 2023-10-19 12:00:00 23 8 1682 8 8
> > datafile.dat 2023-10-19 13:00:00 23 8 1687 8 8
> > datafile.dat 2023-10-19 14:00:00 23 8 1685 8 8
> > datafile.dat 2023-10-19 15:00:00 23 8 1668 8 8
> > datafile.dat 2023-10-19 16:00:00 23 8 2155 8 8
> > datafile.dat 2023-10-19 17:00:00 23 8 2178 8 8
> > datafile.dat 2023-10-19 18:00:00 23 8 2199 8 8
> > datafile.dat 2023-10-19 19:00:00 23 8 2187 8 8
> > datafile.dat 2023-10-19 20:00:00 23 8 2180 8 8
> > datafile.dat 2023-10-19 21:00:00 23 8 2176 8 8
> > datafile.dat 2023-10-19 22:00:00 23 8 2053 8 8
> > datafile.dat 2023-10-19 23:00:00 23 8 2043 8 8
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>