Re: Trigger performance - Mailing list pgsql-performance

From pginfo
Subject Re: Trigger performance
Date
Msg-id 400FF4CF.EF44E795@t1.unisoftbg.com
Whole thread Raw
In response to Trigger performance  (pginfo <pginfo@t1.unisoftbg.com>)
List pgsql-performance
Ok, thanks.
I will do it.

regards,
ivan.

Tom Lane wrote:

> 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: Tom Lane
Date:
Subject: Re: Trigger performance
Next
From: "Shea,Dan [CIS]"
Date:
Subject: database performance and query performance question