Search Postgresql Archives

CPU SPIKE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi All, 

Having real high CPU issue (95-98%), with SELECT statements and select queries contains multiple AND operator, is it will cause any CPU Spike..??? 

apps team is using sub-partition, PG11, CPU:24, Mem: 16GB

```test=# show shared_buffers ;
 shared_buffers
----------------
 7680MB
(1 row)

test=# show work_mem ;
 work_mem
----------
 104MB
(1 row)

test=# show maintenance_work_mem ;
 maintenance_work_mem
----------------------
 1GB
(1 row)

test=# show effective_cache_size ;
 effective_cache_size
----------------------
 22GB
(1 row)
                              
test=# show max_worker_processes;
 max_worker_processes
----------------------
 8
(1 row)

test=#```


Regards, 
Pawan

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux