Well if your working set fits RAM your tables will be stored in memory in the shared buffers.