Having indexes fitting the query is of course important, but it's not postgres specific.