pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedLoss of cache when persistent connexion is closed
2+ messages / 2 participants
[nested] [flat]
* Loss of cache when persistent connexion is closed
@ 2008-01-08 15:35 Guillaume Pungeot <gpungeot@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Guillaume Pungeot @ 2008-01-08 15:35 UTC (permalink / raw)
To: pgsql-performance
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 ?
Regards
--
=========
Guillaume Pungeot - mappy
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Loss of cache when persistent connexion is closed
@ 2008-01-09 00:05 Tom Lane <tgl@sss.pgh.pa.us>
parent: Guillaume Pungeot <gpungeot@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2008-01-09 00:05 UTC (permalink / raw)
To: Guillaume Pungeot <gpungeot@gmail.com>; +Cc: pgsql-performance
"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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-01-09 00:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-08 15:35 Loss of cache when persistent connexion is closed Guillaume Pungeot <gpungeot@gmail.com>
2008-01-09 00:05 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox