On Thursday, December 20, 2012, Charles Gomes wrote:
> Without hyperthreading CPU still not a bottleneck, while I/O is only 10%
> utilization.
>
> top - 14:55:01 up 27 min, 2 users, load average: 0.17, 0.19, 0.14
> Tasks: 614 total, 17 running, 597 sleeping, 0 stopped, 0 zombie
> Cpu(s): 73
On Thursday, December 20, 2012, Charles Gomes wrote:
> True, that's the same I feel, I will be looking to translate the trigger
> to C if I can find good examples, that should accelerate.
>
I think your performance bottleneck is almost certainly the dynamic SQL.
Using C to generate that dynamic
On Tuesday, December 11, 2012, Tom Lane wrote:
> Jeff Janes > writes:
> > On Tue, Dec 11, 2012 at 2:50 AM, Patryk Sidzina
> > > wrote:
> >> The differences come up when you change the "INSERT" to "EXECUTE
> 'INSERT'" (
> >> and i checked this time on 3 machines, one of which was Windows):
>
> >> F
