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

From Adrian Klaver
Subject Re: Increased storage size of jsonb in pg15
Date
Msg-id ce378740-2da4-4bf4-a750-9556ae059c53@aklaver.com
Whole thread Raw
In response to Re: Increased storage size of jsonb in pg15  (Sean Flaherty <sflaherty@grndwork.com>)
Responses Re: Increased storage size of jsonb in pg15  (Sean Flaherty <sflaherty@grndwork.com>)
List 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.klaver@aklaver.com




pgsql-general by date:

Previous
From: Sean Flaherty
Date:
Subject: Re: Increased storage size of jsonb in pg15
Next
From: Ron Johnson
Date:
Subject: vacuumdb did not analyze all tables?=