Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Schema on write is better to live by. Parent comment
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.
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.