Re: Increased storage size of jsonb in pg15

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Increased storage size of jsonb in pg15
Дата
Msg-id ce378740-2da4-4bf4-a750-9556ae059c53@aklaver.com
обсуждение исходный текст
Ответ на Re: Increased storage size of jsonb in pg15  (Sean Flaherty <sflaherty@grndwork.com>)
Ответы Re: Increased storage size of jsonb in pg15
Список 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 по дате отправления:

Предыдущее
От: Sean Flaherty
Дата:
Сообщение: Re: Increased storage size of jsonb in pg15
Следующее
От: Ron Johnson
Дата:
Сообщение: vacuumdb did not analyze all tables?=