[PERFORM] Help: massive parallel update to the same table

2011-03-18 Thread Red Maple
Hi all, Our system has a postgres database that has a table for statistic which is updated every hour by about 10K clients. Each client only make update to its own row in the table. So far I am only seeing one core out of eight cores on my server being active which tells me that the update is bein

Re: [PERFORM] Help: massive parallel update to the same table

2011-03-18 Thread Red Maple
GE plpgsql VOLATILE COST 100; On Fri, Mar 18, 2011 at 12:06 PM, Kevin Grittner < kevin.gritt...@wicourts.gov> wrote: > [rearranged - please don't top-post] > > [also, bringing this back to the list - please keep the list copied] > > Red Maple wrote: > > Kev

Re: [PERFORM] Help: massive parallel update to the same table

2011-03-22 Thread Red Maple
Hi, I have found the bug in my code that made the update to the same row in the table instead of two different row. Now I have all cores up and running 100%. Thank you for all your help. On Fri, Mar 18, 2011 at 3:21 PM, Kevin Grittner wrote: > Red Maple wrote: > > > Here is my fu