[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

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

2011-03-18 Thread Red Maple
, 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 redmaplel...@gmail.com wrote: Kevin Grittner kevin.gritt...@wicourts.gov wrote: It should be parallel

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 kevin.gritt...@wicourts.gov wrote: Red Maple redmaplel