Any robust backend depends deeply on the design of it's data layer. In this area of the architecture development, there are two equally important concerns the system architect should care about. First is how is the data modeled, the second is how the data is accessed. In this post we explore the second field, the way the data is accessed in a Postgres database server.