“When you do alter table on a large table, it acquires an exclusive lock, and what happens is when you're doing that alter, it blocks all the region”

Sahil Walia · Software Engineering Radio - the podcast for professional software developers · Sahil Walia on Schema Changes and Data Migrations

Play from 14:17
14:17

Audio streams from the publisher’s own feed. Verbatim does not host or copy it.

What was described

described that an ALTER TABLE on a large Postgres table acquires an exclusive lock, blocking reads and writes

Said nearby on the same subject

“We get a group of people, hopefully in the same room and around tables… eight tables of like five people”
BS
Ben Shore
Lawyerist Podcast ·
How they work 8 tables, 5 people each Share this moment
“They don't read PDF documents, they don't like tables, they get messed up by icons and pictures... you would always use Word”
♫
Said on The Pay Off with Sylvia Jeffreys
How they work Share this moment
“Write down their name and block them. Block anybody that makes you feel cringe.”
CJ
Courtney Johnson
Built in Public ·
How they work Share this moment
“It locks in a 45 day theatrical exclusivity window, which has been the biggest theater… fear with movie theater disruption.”
MF
Matt Frankel
Motley Fool Hidden Gems Investing ·
Why it worked 45-day exclusivity window Share this moment

Moments like this, every Monday

The strongest new moments on your topics, in the speakers' own words. Free for three topics.

No card. No password. One-click unsubscribe.

Track a competitor?

Pro watches up to 25 names or phrases and emails you the morning after they are said.

See Pro, $29 a month

Verbatim quotes a short extract and links to the episode; the episode belongs to its publisher. Remove a show.