From: Guillaume Pungeot <gpungeot@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Loss of cache when persistent connexion is closed
Date: Tue, 8 Jan 2008 16:35:56 +0100
Message-ID: <95c13b360801080735y181e4f5fs75c0741603f6021c@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gpungeot@gmail.com
Subject: Re: Loss of cache when persistent connexion is closed
In-Reply-To: <95c13b360801080735y181e4f5fs75c0741603f6021c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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