On Wed, 2010-09-22 at 13:06 -0400, Bruce Momjian wrote:
> To confirm, it was majorly hung. Cancel and kill did not work, pg_ctl
> -m fast did not work either. I had to kill -3. Bad. :-(
Yes, that was the problem. I believe the fix is simple, however.
If there had to be a problem with in 9.0.0, but we could pick the
command, I think we would all choose UNLISTEN ;)
As an aside, one of the things that really impressed me about PostgreSQL
so long ago was how quickly you, Tom, and Jan responded to my first
UNLISTEN bug report 10 years ago. It was handled seriously,
professionally, honestly, and openly; even though it seemed like the
most trivial bug that I could imagine at the time.
Regards,
Jeff Davis