On Mon, Jun 27, 2011 at 9:22 AM, Jenish <jenishvyas@xxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
