Re: Postgres processes getting stuck (bug?)

We're running Postgresql 9.0.7...

do note, the 9.0 series got up to 9.0.23 before it was discontinued last year.   9.0.7 was released in February 2012, 4+ years ago.

9.0.18 fixed some index corruption bugs in GIST indexes, 9.0.15 fixed a bunch of other data corruption problems, 9.0.13 fixed yet more GiST index problems.      of course, every one of these incremental updates fixed dozens of relatively obscure bugs, you'd need to read the release notes for each version between 9.0.8 and 9.0.23 for the complete list.

-- 
john r pierce, recycling bits in santa cruz