On Tue, Jan 15, 2013 at 3:44 PM, Horst Dehmer wrote:
> idx_4 together with a simple select in the tables on-insert trigger is
> slowing things down considerably.
So the theory is that the presence of idx_4 is causing the trigger to
pick a poor plan (i.e. one using idx_4) while its absence remov
Ali,
> You can save the source as partition.c and use:
>
> gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv -fpic -DREFINT_VERBOSE -I.
> -I. -I"/usr/pgsql-9.2/include/server
> Date: Thu, 17 Jan 2013 15:38:14 +0100
> Subject: Re: [PERFORM] Performance on Bulk Insert to Partitioned Table
> From: alipou...@gmail.com
> To: charle...@outlook.com
> CC: pgsql-performance@postgresql.org
>
>
> 2012/12/27 Charles Gomes
> mailto:charle.
2012/12/27 Charles Gomes
> So far that's what I got http://www.widesol.com/~charles/pgsql/partition.c
> I had some issues as He uses HeapTuples and on 9.2 I see a Slot.
>
Hi Charles,
I copied your C code partition.c and am trying to test it.
For compiling you suggest :
...
gcc -I "./" -fpic -c
