Understanding JSONB and TOAST tables

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Understanding JSONB and TOAST tables
Date: 2020-06-09 19:48:35
Message-ID: CAOC+FBX_Zwu_Ck4hgFGy3O0vz_HT0i7=Y-ozBVSe9n4+-28G+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is there documentation that lays out how JSONB columns are stored? I have a
Rather Large Table with 37m+ rows with large JSONB objects, its size is
about 300mb, but there's an associated TOAST table with a 28GB size.

Curious how/why PSQL would store JSONB stuff this way.

Thanks!

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2020-06-09 22:59:19 Re: Understanding JSONB and TOAST tables
Previous Message vinod kale 2020-06-09 19:17:04 Re: block corruption message in error logs.