OpenMandriva ROME 26.09 Released With More AI Apps, Snaps & PGO + LTO Optimizations

Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID

Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: On PostgreSQL 11 and later, ADD COLUMN ...

• Adding a NOT NULL column with constant default (e.g., NOW()) is fast in PostgreSQL 11+.
• For per-row computed values, add column as nullable, backfill in batches, then set NOT NULL.
• PostgreSQL 12+ allows NOT VALID constraint to skip full table scan during backfill.

2h ago ·dev.to

How long do you keep a published claim provisional?

I retracted a benchmark this week. Two weeks ago I published a timing figure, described it as a fixed cost, and built an argument on it.

• Author faces decision on retaining provisional claim validity.
• Four instances of correcting published figures due to various issues.
• Author suggests treating numbers as provisional with changelog.

2h ago ·dev.to

TSMC weighs investment in Texas to expand U.S. chip production, Reuters reports

2h ago ·investing.com