We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Large number of Postgres background processes

Follow

Comments

2 comments

  • Avatar
    Sébastien Godet

    Hi! thank you for the article. Is there a way to know when it becomes unormal to have so many backend processes ? We have around 30 backend processes without doing anything in Data360, is this still an expected behavior ?

    Kind regards,

    Sebastien

    0
    Comment actions Permalink
  • Avatar
    Vikrant Kishore

    Hi Sebastien,

    This is normal behavior, PostgreSQL uses a multi-process architecture. All of the processes are just how postgres works, It enables the database to do parallel processing on queries. Each process when idle should sit at around the 2MB mark. When processing queries they will spike in CPU and memory usage, but then will go down to the idle mark.
    The idea behind this seems to be that if a process dies, it won’t take all other processes with it. To avoid if one thread crashes which would then cause the whole application to crash.
    Is performance being impacted in any way?

    Thanks and Regards,

    Vikrant Kishore

    0
    Comment actions Permalink

Please sign in to leave a comment.