Hacker News new | ask | show | jobs
by mannyv 44 days ago
Just don't bother with Postgres.

I've run mysql for years in production and have spent probably 30 minutes thinking about managing it. Unless there's some psql feature you need (unlikely), it'll just become a severe pain in your ass down the road because you set something up "wrong."

Just vacuuming can barf completely, leaving you dead in the water.

TL;DR: if you aren't a DBA and don't want to play one on TV don't bother with psql.

3 comments

Dunno, I'm not a DBA but find Postgres to be fine.
Agreed. And, any time I ask for help with something DB-related, people just chastise me for not running postgres and blindly tell me that's my problem. That sort of community is not what I want to look forward to.
For what it's worth, I would never say that, even though Postgres is my typical choice. MySQL is fine too.
Deadlocks?