Re:Things I hate about PostgreSQL (2020)
by runeks on Tuesday April 06, 2021 @12:00PM
(#26713495)
Devil’s advocate: could it simply be that someone spent 5 months optimizing queries for MySQL before switching to Postgres? Such that Postgres performance isn’t “worse”, it just doesn’t plan queries in the same way that MySQL does.
[ Parent
| on HN ]
Re:Things I hate about PostgreSQL (2020)
by jbluepolarbear on Tuesday April 06, 2021 @01:56PM
(#26715151)
It was definitely that. The queries were built to take advantage of MySQL features.I joined after they just switched and was told to optimize queries. Was a pretty toxic job, I was hired work on streaming media systems (like Hulu, ESPN, etc) but instead they had me doing query optimizations. I quit after 5 months. I was never able talk to my boss once, he avoided me and was always too busy.
That's the kind of job I enjoy doing.
It is just not sexy and some startup rejected me when I said that's what I do.