I'll definitely agree that attempting to run OLTP and analytics queries on a sin... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		rbranson on Feb 4, 2011 \| parent \| context \| favorite \| on: Why PostgreSQL doesn't have query hints 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).

btilly on Feb 4, 2011 [–]

I made it work acceptably well for my use case. But the query optimizer sometimes was doing stupid things.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact