It's possible to get process ids for clients using something like ps
-ef | grep postgres. I wonder, is it safe to use kill to terminate
those threads? If this doesn't mess up the database, it might work.
Hadley Willan wrote:
Thanks for that, however that's quite heavy handed in that it
Hi
I've recently enabled statistics gathering on our large (> 50GB)
postgres database because of a recent significant decrease in
performance, believed to be related to changes in the application
running on top of it. I'm trying to make sense of these statistics in my
investigation of this. Ar