Re: Trigger performance

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(at)Yahoo(dot)com #