> Date: Sat, 29 Dec 2012 23:45:06 -0500
> Subject: Re: [HACKERS] Writing Trigger Functions in C
> From: robertmh...@gmail.com
> To: charle...@outlook.com
> CC: cbbro...@gmail.com; pgsql-hackers@postgresql.org
>
> On Mon, Dec 24, 2012
I'm creating a simple trigger that will be called during an insert and change
the destination table.
All values are going to be preserved, just the destination table will be
different.
From what I see I can't modify trigdata->tg_relation.
All examples use: return Datum(trigdata->tg_trigtuple);
ate: Fri, 21 Dec 2012 11:56:25 -0500
> > Subject: Re: [HACKERS] Writing Trigger Functions in C
> > From: cbbro...@gmail.com
> > To: charle...@outlook.com
> > CC: pgsql-hackers@postgresql.org
> >
> > On Fri, Dec 21, 2012 at 11:25 AM, Charles Gomes
> > mailto:ch
> Date: Fri, 21 Dec 2012 11:56:25 -0500
> Subject: Re: [HACKERS] Writing Trigger Functions in C
> From: cbbro...@gmail.com
> To: charle...@outlook.com
> CC: pgsql-hackers@postgresql.org
>
> On Fri, Dec 21, 2012 at 11:25 AM, Charles Go
Hello guys,
I've been finding performance issues when using a trigger to modify inserts on
a partitioned table.
If using the trigger the total time goes from 1 Hour to 4 hours.
The trigger is pretty simple:
CREATE OR REPLACE FUNCTION quotes_insert_trigger()
RETURNS trigger AS $$
BEGIN
EXECUTE
