Avoiding n+1 queries Using a join Using a second query More preloading strategies Composite types Using JSON as a join alternative Selecting a subset of columns Getting a subset of a one to many relationship Subquery and row_to_json Querying hierarch... Read more...