PostgreSQL Processes question

[nunoricardovaz]

Hey, guys. Is this normal? I have 8.1 Pro.

[_Loki_]

Is this normal?

Yes, It's normal to have quite a few processes for PostgreSQL. PostgreSQL is running even when you have HM2 closed - as you can see from your picture it's not using resources when it's not being used by HM2. You can turn it off, but there's no point in doing so. For more info read this:- https://wiki.postgresql.org/wiki/FAQ...n_when_idle.3F

QUOTE:- "PostgreSQL is process based [it isn't threaded], so it starts one postgres [or postgres.exe on Windows] instance per connection. The postmaster [which accepts connections and starts new postgres instances for them] is always running. In addition, PostgreSQL generally has one or more "helper" processes like the stats collector, background writer, autovacuum daemon, walsender, etc, all of which show up as "postgres" instances in most system monitoring tools. Despite the number of processes, they actually use very little in the way of real resources"

[nunoricardovaz]

Ok, thank you for the answer!