Postgres Pro
Downloads
Home   >   mailing lists

Re: Loss of cache when persistent connexion is closed - Mailing list pgsql-performance

From Tom Lane
Subject Re: Loss of cache when persistent connexion is closed
Date
Msg-id 22396.1199837155@sss.pgh.pa.us
Whole thread Raw
In response to Loss of cache when persistent connexion is closed  ("Guillaume Pungeot" <gpungeot@gmail.com>)
List pgsql-performance
Tree view 
"Guillaume Pungeot" <gpungeot@gmail.com> writes:
> I assume that each postgresql process manage its own cache but that there is
> no global cache. Am I right ?

No, you aren't.

Are you sure you're not shutting down the postmaster?  Just exiting
individual sessions shouldn't result in anything getting discarded
from shared buffers.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Guillaume Pungeot"
Date:
Subject: Loss of cache when persistent connexion is closed
Next
From: "John Smith"
Date:
Subject: Performance of aggregates over set-returning functions