Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 313439FB63D for ; Mon, 12 Feb 2007 13:43:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 07144-10 for ; Mon, 12 Feb 2007 13:43:16 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 266319FB626 for ; Mon, 12 Feb 2007 13:43:16 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1321917ugf for ; Mon, 12 Feb 2007 09:43:15 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=LFFZ+vNL/AzrxqQfaGW7LYBmWxc1ffCKgDirzyr+kfM/VZWuTgWJWq0eJhvXnY0l0avPn7QXGGTa6Re0X3M4DULBB2RANgrGIFO7BqE4ugqCFU+Asz5unAgL4HFTFfxw0FSLRc476sARfEVJNntjvbFSbzLcJNLkAiDpqeRvjDo= Received: by 10.67.89.5 with SMTP id r5mr15360043ugl.1171302195026; Mon, 12 Feb 2007 09:43:15 -0800 (PST) Received: by 10.66.217.13 with HTTP; Mon, 12 Feb 2007 09:43:14 -0800 (PST) Message-ID: <55c095e90702120943v2909044eo91445b0eda3958c7@mail.gmail.com> Date: Mon, 12 Feb 2007 14:43:14 -0300 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org Subject: Deadlock on transaction MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_79169_17385502.1171302194990" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.55 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/157 X-Sequence-Number: 24622 ------=_Part_79169_17385502.1171302194990 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list, I am curious becouse I am seen my postgresql locking the transactions when = i load a huge (in some case not to huge) numbers of records 70,000 records. Could someone help me with it ? --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_79169_17385502.1171302194990 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list,

I am curious becouse I am seen my postgresql locking the tr= ansactions when i load a huge (in some case not to huge) numbers of records= 70,000 records.

Could someone help me with it ?
--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
 &= nbsp;           &nbs= p;            &= nbsp;       Atenciosamente (Sincerely)            &= nbsp;           Ezeq= uias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditadurasThe worst of democracies is still better than the better of dictatorships=
http://ezequiasrocha.blo= gspot.com/ ------=_Part_79169_17385502.1171302194990--