I was under the impression that work_mem would be used for the index if there was an index for the RI lookup. Wrong?
Yes -- work_mem is not used for doing index scans, whether for RI lookups or otherwise.
-Neil
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
