From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Sean Flaherty <sflaherty(at)grndwork(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Increased storage size of jsonb in pg15 |
Date: | 2023-12-13 23:56:09 |
Message-ID: | ce378740-2da4-4bf4-a750-9556ae059c53@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Ron Johnson | 2023-12-14 02:38:52 | vacuumdb did not analyze all tables?= |
Previous Message | Sean Flaherty | 2023-12-13 23:49:41 | Re: Increased storage size of jsonb in pg15 |