Idle in transaction - Explination ..

From: Weslee Bilodeau <weslee(dot)bilodeau(at)hypermediasystems(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Idle in transaction - Explination ..
Date: 2007-01-24 21:15:43
Message-ID: 45B7CC7F.1050703@hypermediasystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Where I work I'm in charge of more then a few PostgreSQL databases.

I understand why idle in transaction is bad, however I have some
developers who I'm having a real difficult time fully explaining to them
why its bad.

Oh, and by bad I mean they have transactions that are sitting idle for
6+ hours at a time.

Mainly because they don't speak very good English, and my words like
MVCC and VACUUM have them tilting their heads wondering what language
I'm speaking.

I've tried searching the mailing lists for a good explanation, but
haven't really found one thats easy to translate.

They are Japanese, but I don't speak Japanese, so finding any resource
in Japanese that explains it is beyond my ability.

Would anyone happen to have a simple explanation, or a page online thats
written in Japanese that I can pass off that might explain why this is bad?

Is there a Wiki somewhere that says "101 ways to cause your DBA an
aneurysm" that covers things like this? :)

Weslee

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeremy Haile 2007-01-24 21:38:00 Re: Stats collector frozen?
Previous Message Rich Shepard 2007-01-24 21:08:04 Re: Cannot Restart PostgreSQL-8.1.4