Search Postgresql Archives

Re: Increased storage size of jsonb in pg15

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux