Re: [ADMIN] Forcing connections closed

2004-01-29 Thread Ryan Chambers
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

[ADMIN] understanding postgres stats

2003-10-15 Thread Ryan Chambers
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