Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group