Understanding JSONB and TOAST tables - Mailing list pgsql-admin

From Wells Oliver
Subject Understanding JSONB and TOAST tables
Date
Msg-id CAOC+FBX_Zwu_Ck4hgFGy3O0vz_HT0i7=Y-ozBVSe9n4+-28G+A@mail.gmail.com
Whole thread Raw
Responses Re: Understanding JSONB and TOAST tables
List 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!

--

pgsql-admin by date:

Previous
From: vinod kale
Date:
Subject: Re: block corruption message in error logs.
Next
From: Peter Eisentraut
Date:
Subject: Re: Understanding JSONB and TOAST tables