Re: Trigger performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: Trigger performance
Date
Msg-id 12833.1074791456@sss.pgh.pa.us
Whole thread Raw
In response to Re: Trigger performance  (pginfo <pginfo@t1.unisoftbg.com>)
List pgsql-performance
pginfo <pginfo@t1.unisoftbg.com> writes:
> In wich case will this trigger work faster if write it in "C"?

Given that the dominant part of the time will be spent down inside SPI
in either case, I doubt you will be able to see much difference.  You
need to think about how to optimize the invoked query, not waste your
time recoding the wrapper around it.

            regards, tom lane

pgsql-performance by date:

Previous
From: pginfo
Date:
Subject: Re: Trigger performance
Next
From: pginfo
Date:
Subject: Re: Trigger performance