We use postgres as the backend on bugs.python.org, and I use it for my
other roundup based trackers.  So it's not true that nobody uses it :)

On the other hand, we *started* with postres, so that could be why we
haven't run into the troubles you have.