Jenish <jenishvyas@gmail.com> wrote:
> I am using postgres 8.4.x
With x being what? On what OS and hardware?
> 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.
http://wiki.postgresql.org/wiki/SlowQueryQuestions
> After insert trigger is recursive trigger.
So are you counting only the top level inserts or also the ones
generated by the recursive inserts?
> My question.
>
> How to avoid the bottleneck?
First you need to find out what the bottleneck is.
> Parallel processing is possible in Postgres? How?
To achieve parallel processing in PostgreSQL you need to use
multiple connections.
-Kevin