News for hackers. Stuff that matters.
Re:Why PostgreSQL doesn't have query hints by rbranson on Friday February 04, 2011 @01:15PM (#2180451)
I'll definitely agree that attempting to run OLTP and analytics queries on a single PostgreSQL server is not going to turn out well. I'm not sure if there's a way around it though, even in theory (e.g. MapReduce isn't very good for OLTP).
Re:Why PostgreSQL doesn't have query hints by btilly on Friday February 04, 2011 @04:42PM (#2181372)
I made it work acceptably well for my use case. But the query optimizer sometimes was doing stupid things.