Re: Embedding code in Postgres source code

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Harpreet Dhaliwal" <harpreet(dot)dhaliwal01(at)gmail(dot)com>
Cc: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Embedding code in Postgres source code
Date: 2007-10-07 18:07:17
Message-ID: 162867790710071107l34d374cbp8b93dcffd0fa3be0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2007/10/7, Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com>:
> Faster by calling external or internal libraries. my concept was calling
> libraries internal to the system would make it faster right ?
>

I thing, so it's not true, because all libraries functions are
directly called. It is different than Microsoft Windows.

Pavel

>
> On 10/7/07, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> > 2007/10/7, Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com>:
> > > My stored procedure is in Perl. Does that really make any difference ?
> > >
> > It depends. If you call external libraries you can be little bit
> > faster. You have to test it.
> >
> > Pavel
> >
> >
> >
> > > On 10/7/07, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com > wrote:
> > > > Hello
> > > >
> > > > If your stored procedure is writen in C language, then storing it
> > > > inside PostgreSQL hasn't any benefit. There is only one difference ..
> > > > loading library needs some time, but you can load any library with
> > > > statement LOAD.
> > > >
> > > > Regards
> > > > Pavel Stehule
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > 2007/10/7, Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com>:
> > > > > Hi,
> > > > >
> > > > > I have a stored procedure that gets called every now and then in my
> > > system.
> > > > > This stored procedure is an implementation of client socket code
> > > basically.
> > > > >
> > > > > If somehow this stored procedure becomes a part of Postgres source
> code,
> > > > > would it really make any difference as far as performance and
> resource
> > > > > utilization of my system is concerned ?
> > > > >
> > > > > Thanks,
> > > > > Hapreet
> > > > >
> > > >
> > >
> > >
> >
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2007-10-07 19:29:27 Re: SLOW Remote Connection to PostgreSQL Database
Previous Message Harpreet Dhaliwal 2007-10-07 18:03:45 Re: Embedding code in Postgres source code