Re: [PERFORM] Performance issue with Insert

morrow. -- Thanks & regards, JENISH VYAS On Mon, Jun 27, 2011 at 10:48 PM, Tomas Vondra wrote: > 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 ,

Re: [PERFORM] Performance issue with Insert

). Scenario : All insert are waiting for previous insert to complete. Cant we avoid this situation ? What is the "max_connections" postgresql support? Plz help -- Thanks & regards, JENISH VYAS On Mon, Jun 27, 2011 at 6:32 PM, wrote: > > Hi, > > > > DB :

Re: [PERFORM] Performance issue with Insert

(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 wrote: > Jenish wrote: > > > I am using postgres 8.4.x >

[PERFORM] Performance issue with Insert

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. -- Thanks & regards, JENISH VYAS

Re: [PERFORM] Strange behavior of child table.

Hi Jeff, Thanks for the help. This is the first post by me, and I did mistake unknowingly. I will take care of it next time. Again thanks a lot for the help. -- Thanks & regards, JENISH VYAS On Thu, Jun 2, 2011 at 10:04 AM, Jeff Davis wrote: > > In the future, please remember to C

[PERFORM] Strange behavior of child table.

action_id. Partition is trigger based. Postgres Version : (PostgreSQL) 8.4.6 Why there is difference in execution time? What I am doing wrong? -- Thanks & regards, JENISH