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 at 10:43 AM, Charles Gomes
On Mon, Dec 24, 2012 at 10:43 AM, Charles Gomes charle...@outlook.com wrote:
And I had no performance improvements at all.
Took the same time as with the previous EXECUTE statement;
I don't see what am I doing wrong.
You might not be doing anything wrong. Triggers ARE slow.
If you have perf
From: charle...@outlook.com
To: cbbro...@gmail.com
CC: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Writing Trigger Functions in C
Date: Fri, 21 Dec 2012 12:27:26 -0500
Date: Fri, 21 Dec 2012 11:56:25 -0500
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
On Fri, Dec 21, 2012 at 10:25 AM, Charles Gomes charle...@outlook.com wrote:
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:
Hello
you can find lot of examples in PostgreSQL source code - see
postgresql/contrib/spi directory
and documentation http://www.postgresql.org/docs/9.0/static/trigger-example.html
Regards
Pavel Stehule
2012/12/21 Charles Gomes charle...@outlook.com:
Hello guys,
I've been finding
On 12/21/2012 08:39 AM, Merlin Moncure wrote:
On Fri, Dec 21, 2012 at 10:25 AM, Charles Gomes charle...@outlook.com wrote:
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
On Fri, Dec 21, 2012 at 11:25 AM, Charles Gomes charle...@outlook.com
wrote:
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:
2012/12/21 Joe Conway m...@joeconway.com:
On 12/21/2012 08:39 AM, Merlin Moncure wrote:
On Fri, Dec 21, 2012 at 10:25 AM, Charles Gomes charle...@outlook.com
wrote:
Hello guys,
I've been finding performance issues when using a trigger to modify inserts
on a partitioned table.
If using
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 Gomes
charle
10 matches
Mail list logo