Skip to content

Tasks · Constraints

Make a column NOT NULL without the scan

The change

`orders.note` has to become NOT NULL. The straightforward statement scans all forty-one million rows under ACCESS EXCLUSIVE. Get to the same schema with writes blocked for under a second.

hard12 minutesblocked-writes budget 1s simulatedpar 0.5s

Reading your progress…
Everything you do here stays in this browser.Part of liter8.sh