From: | Sean Flaherty <sflaherty(at)grndwork(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Increased storage size of jsonb in pg15 |
Date: | 2023-12-14 14:48:08 |
Message-ID: | CAOscTZNAdqiS4kF1ESW5+6eUMtrzR6WyZXgtd0RUTkbramnk3Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Igniris Valdivia Baez | 2023-12-14 15:19:42 | Re: how can I fix my accent issues? |
Previous Message | Filip Sedlák | 2023-12-14 07:53:33 | Re: How to Straming replication chatch up from archive |