Re: [PERFORM] Partition insert trigger using C language

2013-02-15 Thread Ali Pouya
2013/2/13 Matheus de Oliveira > > Hi Ali, > > That is probably because you did not passed a parameter when defined the > trigger. You can follow the model at [1]. When creating the trigger, you > have to use a string parameter with the name of the field with the date > value used for the partitio

Re: [PERFORM] Partition insert trigger using C language

2013-02-13 Thread Matheus de Oliveira
On Mon, Feb 11, 2013 at 1:24 PM, Ali Pouya wrote: > Hi Matheus, > I try to use your partition_insert_trigger_spi.c code for testing SPI > partitionning. > But at execution time the *trigdata->tg_trigger->tgargs* pointer is null. > Do you know why ? > Thanks a lot > Best Reagrds > Ali Pouya > > >

Re: [PERFORM] Partition insert trigger using C language

2013-02-11 Thread Ali Pouya
Hi Matheus, I try to use your partition_insert_trigger_spi.c code for testing SPI partitionning. But at execution time the *trigdata->tg_trigger->tgargs* pointer is null. Do you know why ? Thanks a lot Best Reagrds Ali Pouya 2013/1/11 Matheus de Oliveira > > On Fri, Jan 11, 2013 at 8:19 AM, Hei

Re: [PERFORM] Partition insert trigger using C language

2013-01-11 Thread Matheus de Oliveira
On Fri, Jan 11, 2013 at 9:02 AM, Heikki Linnakangas wrote: > On 11.01.2013 12:36, Matheus de Oliveira wrote: > >> On Fri, Jan 11, 2013 at 8:19 AM, Heikki Linnakangas> vmware.com >> >>> wrote: >>> >> >> One thing that caught my eye: >>> >>> CREATE OR REPLACE FUNCTION partition_insert_trigger_s

Re: [PERFORM] Partition insert trigger using C language

2013-01-11 Thread Heikki Linnakangas
On 11.01.2013 12:36, Matheus de Oliveira wrote: On Fri, Jan 11, 2013 at 8:19 AM, Heikki Linnakangas wrote: One thing that caught my eye: CREATE OR REPLACE FUNCTION partition_insert_trigger_spi() RETURNS trigger LANGUAGE C VOLATILE STRICT AS 'partition_insert_trigger_spi'**,'partition_inser

Re: [PERFORM] Partition insert trigger using C language

2013-01-11 Thread Matheus de Oliveira
0, 2013 2:12 PM > *To:* Heikki Linnakangas > *Cc:* pgsql-performance; Charles Gomes > *Subject:* Re: [PERFORM] Partition insert trigger using C language > > ** ** > > ** ** > > On Thu, Jan 10, 2013 at 4:54 PM, Heikki Linnakangas < > hlinnakan...@vmware.com> wrote

Re: [PERFORM] Partition insert trigger using C language

2013-01-11 Thread Matheus de Oliveira
On Fri, Jan 11, 2013 at 8:19 AM, Heikki Linnakangas wrote: > On 10.01.2013 21:48, Matheus de Oliveira wrote: > >> I have made a small modification to keep the plans, and it got from >> 33957.768ms to 43782.376ms. >> > > If I'm reading results.txt correctly, the avg runtimes are: > > C and SPI_exe

Re: [PERFORM] Partition insert trigger using C language

2013-01-11 Thread Heikki Linnakangas
On 10.01.2013 21:48, Matheus de Oliveira wrote: I have made a small modification to keep the plans, and it got from 33957.768ms to 43782.376ms. If I'm reading results.txt correctly, the avg runtimes are: C and SPI_execute_with_args: 58567.708 ms C and SPI_(prepare/keepplan/execute_plan): 43782

Re: [PERFORM] Partition insert trigger using C language

2013-01-10 Thread Charles Gomes
> From: matioli.math...@gmail.com > Date: Thu, 10 Jan 2013 16:45:43 -0200 > Subject: Partition insert trigger using C language > To: pgsql-performance@postgresql.org > CC: charle...@outlook.com > > Hi All, > > Inspired by Charles' thread and the work of Em

Re: [PERFORM] Partition insert trigger using C language

2013-01-10 Thread Matheus de Oliveira
On Thu, Jan 10, 2013 at 5:22 PM, Heikki Linnakangas wrote: > On 10.01.2013 21:11, Matheus de Oliveira wrote: > >> On Thu, Jan 10, 2013 at 4:54 PM, Heikki Linnakangas> vmware.com >> >>> wrote: >>> >> >> The right way to do this with SPI is to prepare each insert-statement on >>> first invocation

Re: [PERFORM] Partition insert trigger using C language

2013-01-10 Thread Heikki Linnakangas
On 10.01.2013 21:11, Matheus de Oliveira wrote: On Thu, Jan 10, 2013 at 4:54 PM, Heikki Linnakangas wrote: The right way to do this with SPI is to prepare each insert-statement on first invocation (SPI_prepare + SPI_keepplan), and reuse the plan after that (SPI_execute_with_args). If you cons

Re: [PERFORM] Partition insert trigger using C language

2013-01-10 Thread Pavel Stehule
2013/1/10 Heikki Linnakangas : > On 10.01.2013 20:45, Matheus de Oliveira wrote: >> >> Inspired by Charles' thread and the work of Emmanuel [1], I have made some >> experiments trying to create a trigger to make partitioning using C >> language. >> >> The first attempt was not good, I tried to use

Re: [PERFORM] Partition insert trigger using C language

2013-01-10 Thread Matheus de Oliveira
On Thu, Jan 10, 2013 at 4:54 PM, Heikki Linnakangas wrote: > On 10.01.2013 20:45, Matheus de Oliveira wrote: > >> Inspired by Charles' thread and the work of Emmanuel [1], I have made some >> experiments trying to create a trigger to make partitioning using C >> language. >> >> The first attempt

Re: [PERFORM] Partition insert trigger using C language

2013-01-10 Thread Heikki Linnakangas
On 10.01.2013 20:45, Matheus de Oliveira wrote: Inspired by Charles' thread and the work of Emmanuel [1], I have made some experiments trying to create a trigger to make partitioning using C language. The first attempt was not good, I tried to use SPI [2] to create a query to insert into the cor