| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Justin <justin(at)emproshunts(dot)com> |
| Cc: | Sabbiolina <sabbiolina(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Memory question on win32 systems |
| Date: | 2008-05-29 14:30:53 |
| Message-ID: | 20080529143053.GA10943@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2008-05-29 14:33:53 | Re: [PERFORM] Memory question on win32 systems |
| Previous Message | Tom Lane | 2008-05-29 14:28:30 | Re: BUG #4186: set lc_messages does not work |