Postgres, JSON and TOAST #database

[chris-pee]

This pointer and external page are also created when your row size exceeds the page size. Does this mean that there isn't a special case for JSON, and it's just the consequence of how large rows are handled?

[fgceifm]

Does it mean that LOBs and JSONs are stored differently in Postgres?

[williamx]

Without any research I thought it was just stringified. So json in postgres isn’t just stringified but is actually another table internally?

[Ish]

Very relevant nuance, and well explained!

[nageshbs]

this pointer is like a memory offset in a page

[karteekgodavarthi]

What if the size of the page is higher so that it can accommodate the JSON within the page, does it still create a external page?

[pankajkumar-ilsi]

it means json column cannot be indexed?

[deekayjindal]

Is this short part of big video? If yes can you share the video

[mohamedr]

This way of technic affect design of data model