Re: 10.2: high cpu usage on update statement

On 4/5/19 5:45 PM, Kevin Wilkinson wrote:
> on 10.2, we're seeing very high cpu usage when doing an update statement
> on a relatively small table (1GB). one of the updated columns is text,
> about 1k bytes. there are four threads doing similar updates concurrently
> to the same table (but different rows). each thread does an update about
> every two seconds, i.e., the tables gets updated every 1/2 second. the
> stack trace below shows the process *stuck in reading the update results*.
> this seems very odd. has anyone seen something similar?  this is a modest
> server of 8 cores, all of which are 90% busy.

Does the table have supporting indexes?

--
Angular momentum makes the world go 'round.