Query hints are not likely to happen, at least not in the way that they do in other databases. There's been a number of discussions about it and you can see so

Query hints are not likely to happen, at least not in the way that they do in other databases. There's been a number of discussions about it and you can see some of the aftermath at http://wiki.postgresql.org/wiki/OptimizerHintsDiscussion http://wiki.postgresql.org/wiki/OptimizerHintsDiscussion As for Materialzed Views, there's some options there currently, though it looks like native support would be a lot nicer: http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized_Views http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized...