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 3226F3A697B for ; Tue, 14 Dec 2004 06:55:10 +0000 (GMT) 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 56112-01 for ; Tue, 14 Dec 2004 06:54:53 +0000 (GMT) Received: from smtp.lewczuk.com (118.224.149.195.tld.pl [195.149.224.118]) by svr1.postgresql.org (Postfix) with SMTP id C51043A4309 for ; Tue, 14 Dec 2004 06:54:56 +0000 (GMT) Received: (qmail 9312 invoked by uid 700); 14 Dec 2004 06:54:52 -0000 Received: from linux.samar.pl (HELO ?192.168.1.17?) (marek@lewczuk.com@62.233.139.198) by 118.224.149.195.tld.pl with SMTP; 14 Dec 2004 06:54:52 -0000 Message-ID: <41BE8E42.7090306@lewczuk.com> Date: Tue, 14 Dec 2004 07:54:58 +0100 From: Marek Lewczuk User-Agent: Mozilla Thunderbird 0.9 (Windows/20041103) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: Joe Conway Cc: Lista dyskusyjna pgsql-general , Lista dyskusyjna pgsql-admin Subject: Re: plperl loading References: <41BDF725.9030205@lewczuk.com> <41BE0DE4.3050800@joeconway.com> In-Reply-To: <41BE0DE4.3050800@joeconway.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.074 tagged_above=0 required=5 tests=FORGED_RCVD_HELO, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/121 X-Sequence-Number: 15707 Joe Conway napisaƂ(a): > Marek Lewczuk wrote: > >> I've made some tests with plperl and I see that when plperl function >> is executed for the first time, then it takes much more time. I know >> that this is a "shared library" problem - is there a way to preload >> plperl every connection or maybe I can build plperl into postgresql >> source ? > > > See: > http://www.postgresql.org/docs/current/static/runtime-config.html > and search for "preload_libraries" Thanks Joe. This is what I was looking for. ML