Postgres Pro
Downloads
Home   >   mailing lists

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

From Sean Flaherty
Subject Re: Increased storage size of jsonb in pg15
Date
Msg-id CAOscTZNAdqiS4kF1ESW5+6eUMtrzR6WyZXgtd0RUTkbramnk3Q@mail.gmail.com
Whole thread Raw
In response to Re: Increased storage size of jsonb in pg15  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Increased storage size of jsonb in pg15  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Increased storage size of jsonb in pg15  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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.


On Wed, Dec 13, 2023 at 4:56 PM Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com

pgsql-general by date:

Previous
From: Filip Sedlák
Date:
Subject: Re: How to Straming replication chatch up from archive
Next
From: Igniris Valdivia Baez
Date:
Subject: Re: how can I fix my accent issues?