Hello team,
We are using postgresql 14.5 for one of our applications. we are using timescaledb extensions for a use case. we are freuqently observing messages like
worker took too long to start canceled and we see multiple defunct processess in postgres. We are unable to login to postgres and apps are also not able to connect. killing all the defunct processess is also not working. only killing the main postmaster process and restarting the database fixes the issue. we are facing this almost as frequently as 4 to 5 times a day. Any help would be appreciated
Regards,
Sharath