Hello, I have a problem with my install of postgresql. I have a program that requests DB by opening persistent connexions. When the program is launched, the disk IO are very high until postgresql cache is good enough (a few hours). The problem is that when I stop the program all the connexions are closed and so are the postrgesql processes. And the cache is lost. I really want to use postgresql but today I use mssqlserver and it never lost its cache till I stop it (mssqlserver). So I don't have problem with disk IO when the program is stopped an restarted.
I assume that each postgresql process manage its own cache but that there is no global cache. Am I right ? If true is there any possibility to have a global cache for all processes and is it possible not to free this cache when connexions are closed ?