X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C274C32A00B for ; Tue, 19 Oct 2004 06:54:53 +0100 (BST) 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 59598-04 for ; Tue, 19 Oct 2004 05:54:43 +0000 (GMT) Received: from ns2.instrumentalyst.com (blk-222-55-203.eastlink.ca [24.222.55.203]) by svr1.postgresql.org (Postfix) with SMTP id 1D75C329F48 for ; Tue, 19 Oct 2004 06:54:42 +0100 (BST) Received: (qmail 1738 invoked by uid 6002); 19 Oct 2004 05:59:38 -0000 Received: from 68.56.170.170 by ns2.instrumentalyst.com (envelope-from , uid 4002) with qmail-scanner-1.23 (clamdscan: 0.75.1. spamassassin: 3.0.0. Clear:RC:1(68.56.170.170):. Processed in 0.123982 secs); 19 Oct 2004 05:59:38 -0000 Received: from unknown (HELO ?192.168.2.2?) (68.56.170.170) by blk-222-55-203.eastlink.ca with SMTP; 19 Oct 2004 05:59:38 -0000 Message-ID: <4174AC40.1010401@productivitymedia.com> Date: Tue, 19 Oct 2004 01:55:12 -0400 From: Postgres User User-Agent: Mozilla Thunderbird 0.8 (Macintosh/20041018) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Joshua D. Drake" Cc: pgsql-admin@postgresql.org Subject: Re: PREPARE/EXECUTE questions... custom functions? References: <4142008A.2010108@productivitymedia.com> <4143408B.7040604@ca.afilias.info> <41742364.7070601@productivitymedia.com> <41742C60.8030602@commandprompt.com> In-Reply-To: <41742C60.8030602@commandprompt.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, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/228 X-Sequence-Number: 15221 Joshua D. Drake wrote: > Use a connection pooler like pgpool. Thanks for the suggestion, I will look into it and test. There seems to some overhead using that tool. What about custom functions, written in SQL or C? They seem to work until the database is shut down, any thoughts about that for a custom application? Pros/Cons... Thanks in advance, J