Sayad Xiarkakh
  • Member for 5 years, 5 months
  • Last seen more than 2 years ago
  • Kabul, Afghanistan
Does 'max_worker_processes' include background process from postmaster?
0 votes

I believe that they are two different processes and max_process_workers does not include the bg process. Both of them are set and defined separately. If you are talking about backgroud WOKER process (...

View answer
How can I UPDATE multiple ROWs in a Single Query with multiple WHERE clauses?
0 votes

You can use below one for one table if you want to update many columns of one table. UPDATE table SET col1 = CASE WHEN col3 = 'name1' THEN 'a' WHEN col3 = '2' THEN b ELSE 0 ...

View answer