On 04/28/12 17:17, Jeff Frost wrote:
> Since I had a theory that it's probably stalling on pg_catalog access, one of the guys wrote a test harness that makes several connections and creates and drops lots of temp tables. That does seem to allow us to reproduce the issue in the production DB, but not in a newly created DB. So, we're about to initdb a new data directory and slony replicate the data over to it on the original server.
After slony replicating over to the freshly initdb'd original server, the
problem has not recurred. Maybe the problem was catalog corruption?