I don’t want to be a jackass, but if you discover something that’s common knowledge, it’s probably a good idea not to act like it’s a major discovery, because people who click on a misleading linkbaity headline aren’t going to be happy with what they see.
I was on Hacker News tonight, and it turns out that someone discovered that you can “cut down database imports by a third using this one weird trick“. Lo and behold, that weird trick is to turn off indexes when doing bulk imports (this is ETL 101, by the way). At least the blog entry credits the Postgresql manual for giving them that ground breaking piece of information… so there’s that, I guess.
Other articles by this author:
- Wheels, Mousetraps and Other Clichés
- Easy Database Version Control (a.k.a. migrations) with Flyway
- Quick Hit: PostgreSQL performance on Raspberry Pi
- Get To Know Extrata, Episode 2: Database Writeback
- Are good people really that hard to find?