dev-python/psycopg has major issues with PPC64, most notably placeholders don't work and prevent doing any real work. Upstream has reported a few 64bit-related bugfixes and 2.0.6 works much better, using the same ebuild.
Created attachment 125621 [details] Overlay to install 2.0.6
Committed. Thanks for reporting.