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
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
>
>
>
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
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
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
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
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
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
> 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
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
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
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
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
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
14 matches
Mail list logo