> > A quick question, when pg receives data to be written to a> table, does it cache that data in memory in case a> subsequent request/query would need it?>
Afaik all pages are modified in memory, so the modified data would still be cached.