Re: [GENERAL] Question about PG cache selection strategy

2006-11-26 Thread Jim Nasby
On Nov 23, 2006, at 8:37 AM, Sefer Tov wrote: oddities. Clearly the caching algorithm favors caching the indices to data (since they are more frequently accessed) but there is another case where *recently written* entries are often requested shortly after and I am not sure that they get prio

[GENERAL] Question about PG cache selection strategy

2006-11-23 Thread Sefer Tov
Hi, I'm running a very large and frequently updated database on a machine with relatively limited memory (you can safely assume that the database disk usage to available memory has a ratio of 10:1 - so clearly not all the pages can be retained in memory). The naive approach would presume tha