News for hackers. Stuff that matters.
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.
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.
Re:Things I hate about PostgreSQL (2020) by Shorel on Friday April 09, 2021 @08:51AM (#26749886)
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.

Re:Things I hate about PostgreSQL (2020) by nomel on Tuesday April 06, 2021 @08:52PM (#26719296)
The purpose of a query engine is so I don't have to think about this stuff. Computers are supposed to do work for me, no the other way around, dangit!