Tom Lane wrote:
I'm still not very sure why you're hitting the problem more often than other people. There might be some tweak you could make in your application code to dodge the issue.
The initial size of the local lock hash table is 128. That's a lot of locks, most applications probably don't use that many locks and therefore avoid the issue.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match