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 10:56:01
Message-ID: 162867790710070356q39dc89f5r840b6fb8d06c16@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harpreet Dhaliwal 2007-10-07 16:37:26 Re: Embedding code in Postgres source code
Previous Message Joe Masters 2007-10-07 10:31:40 Install fails on Debian sid