X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 19D519DC813 for ; Sat, 21 Jan 2006 04:00:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07165-08 for ; Sat, 21 Jan 2006 04:00:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pop.xnet.hr (dns1.xnet.hr [82.193.192.5]) by postgresql.org (Postfix) with ESMTP id DF2649DC80E for ; Sat, 21 Jan 2006 04:00:15 -0400 (AST) Received: (qmail 10147 invoked from network); 21 Jan 2006 08:00:45 -0000 Received: by simscan 1.1.0 ppid: 10138, pid: 10140, t: 0.4931s scanners: attach: 1.1.0 clamav: 0.87/m:34/d:1131 spam: 3.1.0 Received: from unknown (HELO ?83.139.74.33?) (83.139.74.33) by pop.xnet.hr with SMTP; 21 Jan 2006 08:00:44 -0000 Message-ID: <43D1E9E0.3000905@zg.htnet.hr> Date: Sat, 21 Jan 2006 08:59:28 +0100 From: Rikard Pavelic User-Agent: Thunderbird 1.5 (Windows/20051201) MIME-Version: 1.0 To: "Jim C. Nasby" CC: pgsql-performance@postgresql.org Subject: Re: [PERFORMANCE] Stored Procedures References: <43D130EF.3010205@zg.htnet.hr> <20060120191031.GO20182@pervasive.com> <43D13C2F.1030203@zg.htnet.hr> <20060120213455.GT20182@pervasive.com> In-Reply-To: <20060120213455.GT20182@pervasive.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.479 required=5 tests=[AWL=0.000, DNS_FROM_RFC_ABUSE=0.479] X-Spam-Score: 0.479 X-Spam-Level: X-Archive-Number: 200601/384 X-Sequence-Number: 16862 Jim C. Nasby wrote: > If you're dealing with something that's performance critical you're not > going to be constantly re-connecting anyway, so I don't see what the > issue is. > I really missed your point. In multi user environment where each user uses it's connection for identification purposes, this seems like a reasonable optimization. I know there is pgpool, but it's non windows, and it's not the best solution for every other problem.