Help: massive parallel update to the same table

From: Red Maple <redmapleleaf(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Help: massive parallel update to the same table
Date: 2011-03-18 13:05:23
Message-ID: AANLkTin28GrTBh3GKkSpikqQAGdoVQVichF4=AvjWbLi@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 being done serial
instead of being parallel. Do you know if there is a way for me to make
these independent updates happen in parallel?

Thank you, your help is very much appreciated!

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Reid Thompson 2011-03-18 14:05:33 Re: Help with Query Tuning
Previous Message Arjen van der Meijden 2011-03-18 12:44:51 Re: Request for feedback on hardware for a new database server