Jenish <jenishvyas@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
