On Fri, Jan 30, 2015 at 2:14 PM, <charles(dot)harwood(at)zuerchertech(dot)com> wrote:
> Many postgres worker processes stopped responding. They continued to be in
> state 'active' and not 'waiting' for hours. Each query was on the table
> that an autovacuum process was also hung on processing and was the oldest
> active transaction on.
Was pg_upgrade run on this database at some point [1]?
I foresee more problems here...
[1] http://www.postgresql.org/message-id/20140825225029.2536.5315@wrigleys.postgresql.org
--
Peter Geoghegan