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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных