Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Kevin Grittner
Jenish wrote: > This server is the dedicated database server. > > And I am testing the limit for the concurrent active users. When I > am running my test for 400 concurrent user ie. Active connection. > I am getting good performance but when I am running the same the > same test for 950 concurr

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Tomas Vondra
Dne 27.6.2011 22:14, Jenish napsal(a): > And I am testing the limit for the concurrent active users. When I am > running my test for 400 concurrent user ie. Active connection. I am > getting good performance but when I am running the same the same test > for 950 concurrent users I am getting very

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Jenish
Hi , This server is the dedicated database server. And I am testing the limit for the concurrent active users. When I am running my test for 400 concurrent user ie. Active connection. I am getting good performance but when I am running the same the same test for 950 concurrent users I am getting

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Tomas Vondra
Dne 27.6.2011 17:01, Jenish napsal(a): > 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 How much data are we talking about? Does that fit into the shared buffers or is it significantly larger? Do the trigger

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Tomas Vondra
Dne 27.6.2011 17:58, Jenish napsal(a): > > Hi, > > I have already checked all the statements present in the trigger, no one > is taking more then 20 ms. > > I am using 8-Processor, Quad-Core Server ,CPU utilization is more then > 90-95 % for all. (htop result) So all cores are 95% utilized? Tha

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Merlin Moncure
On Mon, Jun 27, 2011 at 9:22 AM, Jenish 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 seco

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Jenish
Hi, I have already checked all the statements present in the trigger, no one is taking more then 20 ms. I am using 8-Processor, Quad-Core Server ,CPU utilization is more then 90-95 % for all. (htop result) DB has 960 concurrent users. io : writing 3-4 MB per second or less (iotop result). Scen

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread tv
> 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 inser

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Jenish
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(app

Re: [PERFORM] Performance issue with Insert

2011-06-27 Thread Kevin Grittner
Jenish 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 t

[PERFORM] Performance issue with Insert

2011-06-27 Thread Jenish
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 inser