News for hackers. Stuff that matters.
Re:Schema on write is better to live by by tomnipotent on Sunday August 22, 2021 @02:13AM (#28263316)
This works surprisingly well.

I end up just doing both - having one table store the blob, and another with the copied values (shopify_sales, shopify_sales_jsonb).

Databases are generally pretty good at handling large BLOBS/off-page heap values, but I prefer not to tempt the fates of buffer pool management.

There are no comments on this comment yet.