On Thu, May 29, 2008 at 10:19:46AM -0400, Justin wrote: > To my understanding Postgresql only caches queries and results in memory > for that specific connection. So when that connection is closed those > cached results are cleared out. So cached indexs and queries are for > that connection only. I hope my understanding is correct.
Incorrect, the shared buffer cache is shared between all running postgresql processes and between connections. Also the OS cache is shared between all programs on the system. Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
