Обсуждение: Trigger performance

Hi all,

I will to find any info about the trigger performance in postgresql.

I testet a little example and wrote a trigger in plpgsql, but it is very slow.

Will be better to write triggers in "C"?

any info will be great.

Peter Dimov wrote:
>
> Hi all,
>
> I will to find any info about the trigger performance in postgresql.
>
> I testet a little example and wrote a trigger in plpgsql, but it is very slow.
>
> Will be better to write triggers in "C"?
>
>
>
> any info will be great.

    You're  absolutely  right,  any  info will be great. With the
    info you gave us above, it's  impossible  to  tell  why  it's
    slow. Would you mind to tell us a few more details?

    Structures  of  tables  involved,  number  of  rows  in them,
    indexes on them, the trigger code ...


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #