Coincidentally, I was dreading having to add an index on a multigigabyte table t... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		stronglikedan on July 11, 2014 \| parent \| context \| favorite \| on: Zero-downtime database migrations Coincidentally, I was dreading having to add an index on a multigigabyte table this weekend, because I didn't know whether or not it would be done in time for Monday morning business. You just helped put my mind at ease, so I can have a stress-free weekend. Thanks for the tip!

ojilles on July 11, 2014 | [–]

Just be sure to test in a non production database first, I have seen PTOSC crash certain MySQL versions.

jeffdavis on July 11, 2014 | [–]

I assume you're using mysql, but for those using postgres, there is CREATE INDEX CONCURRENTLY.

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact