Eduardo Piombino <drakorg@gmail.com> writes:
> Do you have any idea on what could be causing a SELECT NOW() to never come
> back?
That's truly bizarre. Can you attach to one of these stuck processes
with a debugger and get a stack trace?
regards, tom lane