Re: Performance issue with Insert

On Mon, Jun 27, 2011 at 9:22 AM, Jenish <jenishvyas(at)gmail(dot)com> wrote:
> Hi All,
>
> I am facing some performance issue with insert into some table.
>
> I am using postgres 8.4.x
>
> Table is having 3 before insert trigger and one after insert trigger.
>
> With all triggers enable it is inserting only 4-5 record per second.
>
> But if I disable after insert trigger it is able to insert 667 records per
> second.
>
> After insert trigger is recursive trigger.
>
> My question.
>
> How to avoid the bottleneck?
>
> Parallel processing is possible in Postgres? How?
>
> Please give you suggestion.

this sounds like a coding issue -- to get to the bottom of this we are
going to need to see the table and the triggers.

merlin