Of course, anyone can make an error that causes a query to run forever, just as easily as a spelling typo! :-)
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных