Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
nasretdinov
on May 15, 2025
|
parent
|
context
|
favorite
| on:
Migrating to Postgres
Does adding a default value into a column finally work without locking up an entire table now at least?
williamdclt
on May 15, 2025
|
next
[–]
Yes, it has for a few years :) There's almost always non-locking ways to migrate things with Postgres now
luhn
on May 15, 2025
|
prev
[–]
Like most ALTER TABLE subcommands, you need an exclusive lock on the table while the catalog is updated. But no table scan or rewrite is required, so that lock is sub-second and can usually be done without disrupting a live application.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: