Hi Satyajit:
Can't tell what is going on from the task manager list. Looks like a normal task list for PostgreSQL. Keep in mind PG is a process based application NOT a threaded application. Meaning postgresql starts/forks a new process for every connection. This means we can see each sessions activity from the task manager.
Need to look at the postgresql logs to see why PG may be hung or possibly query pg_stat_activity ....
Can't tell what is going on from the task manager list. Looks like a normal task list for PostgreSQL. Keep in mind PG is a process based application NOT a threaded application. Meaning postgresql starts/forks a new process for every connection. This means we can see each sessions activity from the task manager.
Need to look at the postgresql logs to see why PG may be hung or possibly query pg_stat_activity ....
On Wed, Jun 26, 2024 at 1:06 PM satyajit patra <satyajit.patra@xxxxxxxxxxxxxxxx> wrote:
Dear Team,
I am using postgres database in windows 10 but suddenly we are facing some hang issue while starting the cluster and also, we observe few below process in the task manager. Is it bad impact to the database ?
