От
Rick Gigger
Тема
Дата
Msg-id
CD7D21A1-07AF-4DEB-9754-82FEF9C3BF92@alpinenetworking.com
Список
Дерево обсуждения
Rick Gigger <rick@alpinenetworking.com>
Re: Tom Lane <tgl@sss.pgh.pa.us>
Every once in a while I've noticed the number of processes I've got running jumps up a little higher than normal. So I check it out and realize that I'm building up a bunch of processes that just aren't completing. About half of the one's not completing say "SELECT waiting". I'm not doing anything that I am aware of that could be blocking anything. I am only doing regular vacuums. I am not explicitly locking anything that I know of. Is there a way to figure out what each of these processes are waiting on?
В списке pgsql-general по дате отправления