alt Hacker NewsJust 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.
Replies
ranger_danger • today at 5:14 AM
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.
financltravsty • today at 2:42 AM
Deadlocks?
Dunno, I'm not a DBA but find Postgres to be fine.