On 9/07/2011 8:26 PM, pasman pasmański wrote:
> Reality is crude, seems than this idea is not as good as i think :(
>
> Thanks for answer.
No worries.
For what it's worth, PostgreSQL caches recently used tuples in shared
memory anyway. The OS caches disk data in RAM too. So if the foreign key
is often checked and frequently used, it will often stay in cache.
--
Craig Ringer
POST Newspapers
276 Onslow Rd, Shenton Park
Ph: 08 9381 3088 Fax: 08 9388 2258
ABN: 50 008 917 717
http://www.postnewspapers.com.au/