"Brock Peabody" <brock.peabody@npcinternational.com> writes:
>> Can you reliablly reproduce the problem?
> I can here :). I'm trying to figure out a way for someone to repeat it
> outside my environment but I'm afraid it's got something to do with
> timing. I have 50 threads that are collecting data. If I give each one
> its own connection to the database the problem happens quickly. If they
> all share one connection the problem does not happen.
Perhaps you could whittle down your app into a testbed that just sends
dummy data with about the same timing as the real app?
regards, tom lane