Help: massive parallel update to the same table

Поиск
Список
Период
Сортировка
От Red Maple
Тема Help: massive parallel update to the same table
Дата
Msg-id AANLkTin28GrTBh3GKkSpikqQAGdoVQVichF4=AvjWbLi@mail.gmail.com
обсуждение исходный текст
Ответы Re: Help: massive parallel update to the same table  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Help: massive parallel update to the same table  ("Nicholson, Brad (Toronto, ON, CA)" <bnicholson@hp.com>)
Список 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 по дате отправления:

Предыдущее
От: Reid Thompson
Дата:
Сообщение: Re: Help with Query Tuning
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Help: massive parallel update to the same table