Hi, DB : POSTGRES 8.4.8 OS : Debian HD : SAS 10k rpm
Shared_buffer is 4096 25 % of RAM , effective_cache is 8GB 75% of RAM After insert trigger is again calling 2 more trigger and insert record in another table depends on condition. with all trigger enable there are 8 insert and 32 updates(approx. update is depends on hierarchy) Plz explain multiple connections. Current scenario application server is sending all requests. -- Thanks & regards, JENISH VYAS On Mon, Jun 27, 2011 at 5:37 PM, Kevin Grittner <kevin.gritt...@wicourts.gov > wrote: > Jenish <jenishv...@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 >