Re: Trigger performance - Mailing list pgsql-general

From Jan Wieck
Subject Re: Trigger performance
Date
Msg-id 200205131337.g4DDbrs01863@saturn.janwieck.net
Whole thread Raw
In response to Trigger performance  (Peter Dimov <jquest_j@yahoo.com>)
List pgsql-general
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 #



pgsql-general by date:

Previous
From: Uros Gruber
Date:
Subject: don't know how to get SELECT
Next
From: Joe Conway
Date:
Subject: Re: can Function return a row ???