Help: massive parallel update to the same table - Mailing list pgsql-performance

From Red Maple
Subject Help: massive parallel update to the same table
Date
Msg-id AANLkTin28GrTBh3GKkSpikqQAGdoVQVichF4=AvjWbLi@mail.gmail.com
Whole thread Raw
Responses Re: Help: massive parallel update to the same table
Re: Help: massive parallel update to the same table
List 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!

pgsql-performance by date:

Previous
From: Reid Thompson
Date:
Subject: Re: Help with Query Tuning
Next
From: "Kevin Grittner"
Date:
Subject: Re: Help: massive parallel update to the same table