Joseph Shraibman wrote:
> Does pg know to keep indexes in memory and release table data? Does it
> use an lru algorithm or does it know that certain tables are hit more
> often and others and should be given prefrence?
And when it has to do a seq scan on a table does it start with what is in the cache before
it goes to the os to read from the disk?