Re: Loss of cache when persistent connexion is closed

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Guillaume Pungeot" <gpungeot(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Loss of cache when persistent connexion is closed
Date: 2008-01-09 00:05:55
Message-ID: 22396.1199837155@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Guillaume Pungeot" <gpungeot(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message John Smith 2008-01-09 02:21:46 Performance of aggregates over set-returning functions
Previous Message Tom Lane 2008-01-08 17:25:11 Re: Linux/PostgreSQL scalability issue - problem with 8 cores