Re: High CPU usage

2022-10-22 Thread Thomas Kellerer
ertan.kucuko...@1nar.com.tr schrieb am 20.10.2022 um 21:59: Hello, I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very high CPU usage on my Linux system as below PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+ COMMAND 2357756 postgres 20 0

Re: High CPU usage

2022-10-22 Thread Adrian Klaver
On 10/20/22 12:59, ertan.kucuko...@1nar.com.tr wrote: Hello, I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very high CPU usage on my Linux system as below PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+ COMMAND 2357756 postgres 20 0 2441032

Re: High CPU usage

2022-10-20 Thread Thomas Guyot
On 2022-10-20 15:59, ertan.kucuko...@1nar.com.tr wrote: Hello, I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very high CPU usage on my Linux system as below PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+ COMMAND 2357756 postgres 20 0 2441032

High CPU usage

2022-10-20 Thread ertan.kucukoglu
Hello, I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very high CPU usage on my Linux system as below PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+ COMMAND 2357756 postgres 20 0 2441032 2,3g 4 S 298,7 67,9 2114:58 Tspjzj2Z I could not

Re: 10.2: high cpu usage on update statement

2019-04-08 Thread Kevin Wilkinson
resolved. sorry for not posting the resolution earlier. it was a good puzzler. turns out the postgresql server used network-attached disks. and the updated table had no index for the updated columns. so, the update required a serial scan of the table over the network. thus, the high cpu usage

Re: 10.2: high cpu usage on update statement

2019-04-07 Thread Laurenz Albe
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 diff

Re: 10.2: high cpu usage on update statement

2019-04-05 Thread Ron
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 diff

10.2: high cpu usage on update statement

2019-04-05 Thread Kevin Wilkinson
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

Re: High CPU usage in postgres servers

2017-12-25 Thread Michael Paquier
On Mon, Dec 25, 2017 at 06:12:05PM -0500, Melvin Davidson wrote: > On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj wrote: >> Hi guys , >> when check the task manager I see these many postgres.exe are running. How >> to identify which pid is running for which process please any one can help >> me out.

Re: High CPU usage in postgres servers

2017-12-25 Thread Melvin Davidson
On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj wrote: > > > > Hi guys , > when check the task manager I see these many postgres.exe are running. How > to identify which pid is running for which process please any one can help > me out. > or Why these many postgres.exe are running on the server > >

High CPU usage in postgres servers

2017-12-25 Thread nikhil raj
Hi guys , when check the task manager I see these many postgres.exe are running. How to identify which pid is running for which process please any one can help me out. or Why these many postgres.exe are running on the server [image: Inline image 1] Thanks , Nikhil