Re: PostgreSQL Function Language Performance: C vs PL/PGSQL - Mailing list pgsql-performance

From Stephen Frost
Subject Re: PostgreSQL Function Language Performance: C vs PL/PGSQL
Date
Msg-id 20100526164716.GC21875@tamriel.snowman.net
Whole thread Raw
In response to Re: PostgreSQL Function Language Performance: C vs PL/PGSQL  (Eliot Gable <egable+pgsql-performance@gmail.com>)
Responses Re: PostgreSQL Function Language Performance: C vs PL/PGSQL  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
* Eliot Gable (egable+pgsql-performance@gmail.com) wrote:
> Since PostgreSQL is written in C, I assume there is no
> such additional overhead. I assume that the PL/PGSQL implementation at its
> heart also uses SPI to perform those executions. Is that a fair statement?

Right, but I also wouldn't expect a huge improvment either, unless
you're calling these queries a ton, or the queries that you're calling
from the pl/pgsql are pretty short-lived.

Don't get me wrong, C is going to be faster, but it depends on exactly
what's going on as to if it's going to be an overall improvment of, say,
10%, or a 10-fold improvment. :)

    Thanks,

        Stephen

Attachment

pgsql-performance by date:

Previous
From: Eliot Gable
Date:
Subject: Re: PostgreSQL Function Language Performance: C vs PL/PGSQL
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: performance of temporary vs. regular tables