From: Rick Gigger <rick(at)alpinenetworking(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject:
Date: 2006-01-24 15:43:22
Message-ID: CD7D21A1-07AF-4DEB-9754-82FEF9C3BF92@alpinenetworking.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

  • Re: at 2006-01-24 15:58:47 from Tom Lane

Browse pgsql-general by date

  From Date Subject
Next Message Tony Caduto 2006-01-24 15:44:49 Re: Does this look ethical to you?
Previous Message Peter Wilson 2006-01-24 15:42:10 Re: Does this look ethical to you?