Re: Trigger performance

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Trigger performance
Date: 2004-01-22 17:10:56
Message-ID: 12833.1074791456@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

pginfo <pginfo(at)t1(dot)unisoftbg(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Shea,Dan [CIS] 2004-01-22 19:47:04 database performance and query performance question
Previous Message pginfo 2004-01-22 16:05:35 Re: Trigger performance