Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 384122E3652 for ; Tue, 8 Jan 2008 11:36:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 47840-07 for ; Tue, 8 Jan 2008 11:35:59 -0400 (AST) Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.186]) by postgresql.org (Postfix) with ESMTP id 60A742E2E80 for ; Tue, 8 Jan 2008 11:36:05 -0400 (AST) Received: by mu-out-0910.google.com with SMTP id i10so6819775mue.5 for ; Tue, 08 Jan 2008 07:36:03 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=MALqwlDKwsXugy52ux3TRNCU6cyoTYrjXQhnTBzRKA8=; b=ggRJ7LBc4a86s/ibjaiBgX7AqRPzBLX4hzZH02G0UBlH/rReBdeHQdB0f6EKH9cBSR21Far3XRAU1PYhVicGjbGPoZ4EfUGJjHmXA4j8N9CyAGzAvLeSXtsboYBDn913a4fupQShTo7vzgaVe3gABkMkkGADvVoae+eyFIc3p6U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=cCu7/YkaWjFX2xgC2Szd7EMgx/UuQkNBi+a5ltoekrNDVY/YJTEoLL2SVyGf2aD7094GuZ9BwjqOSRkzUPwCr8kpaDKK8gYUixBRLo3H/IHdPSVfQeJyfjd5kWXSDWQCjNO8iR0ij1mck5r5cr8VgOcx+X1UHlrev2d0O6WZsb0= Received: by 10.78.146.11 with SMTP id t11mr834891hud.2.1199806561400; Tue, 08 Jan 2008 07:36:01 -0800 (PST) Received: by 10.78.205.9 with HTTP; Tue, 8 Jan 2008 07:35:56 -0800 (PST) Message-ID: <95c13b360801080735y181e4f5fs75c0741603f6021c@mail.gmail.com> Date: Tue, 8 Jan 2008 16:35:56 +0100 From: "Guillaume Pungeot" To: pgsql-performance@postgresql.org Subject: Loss of cache when persistent connexion is closed MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_14150_10915409.1199806561397" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/27 X-Sequence-Number: 28266 ------=_Part_14150_10915409.1199806561397 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_14150_10915409.1199806561397 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_14150_10915409.1199806561397--