X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id D14E4D88AB
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 16 Nov 2005 18:59:26 -0400 (AST)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 64017-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Wed, 16 Nov 2005 22:59:28 +0000 (GMT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from mail.clickdiario.com (mail.clickdiario.com [70.85.167.114])
	by svr1.postgresql.org (Postfix) with ESMTP id 4EAE9D6D16
	for <pgsql-performance@postgresql.org>;
	Wed, 16 Nov 2005 18:59:23 -0400 (AST)
Received: from localhost (localhost [127.0.0.1])
	by mail.clickdiario.com (Postfix) with ESMTP id BF91F10005;
	Wed, 16 Nov 2005 17:06:45 -0600 (CST)
Received: from mail.clickdiario.com ([127.0.0.1])
	by localhost (mail.clickdiario.com [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id 08481-04; Wed, 16 Nov 2005 17:06:45 -0600 (CST)
Received: by mail.clickdiario.com (Postfix, from userid 5001)
	id A583710064; Wed, 16 Nov 2005 17:06:45 -0600 (CST)
Received: from cristian1 (unknown [216.230.131.226])
	by mail.clickdiario.com (Postfix) with ESMTP id 70C6610005;
	Wed, 16 Nov 2005 17:06:44 -0600 (CST)
From: "Cristian Prieto" <cristian@clickdiario.com>
To: <pgpool-general@pgfoundry.org>,
	<pgsql-performance@postgresql.org>
Subject: PgPool and Postgresql sessions...
Date: Wed, 16 Nov 2005 16:56:42 -0600
Message-ID: <007601c5eb01$04436ef0$6500a8c0@gt.ClickDiario.local>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 11
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Thread-Index: AcXrAQKifZg6wAaXRHeJ1yGHR0sMdw==
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at example.com
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0 required=5 tests=[none]
X-Spam-Score: 0
X-Spam-Level: 
X-Archive-Number: 200511/305
X-Sequence-Number: 15562

Hi, I just have a little question, does PgPool keeps the same session
between different connections? I say it cuz I have a server with the
following specifications:

P4 3.2 ghz
80 gig sata drives x 2
1 gb ram
5 ips
1200 gb bandwidth
100 mbit/s port speed.

I am running a PgSQL 8.1 server with 100 max connection, pgpool with
num_init_children = 25 and max_pool = 4. I do the same queries all the time
(just a bunch of sps, but they are always the same). Using explain analyze I
get the fact that the sps are using a lot of time the first time they
execute (I guess preparing the plan and the sps I wrote en plpgsql) so I
would like to reuse the session the most possible. I need to serve 10M of
connection per day. Is this possible? (the client is a webapplication, I
repeat again, the queries are always the same).

Thanks a lot for your help...