Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E61699FA027 for ; Mon, 12 Feb 2007 14:08:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 78324-08 for ; Mon, 12 Feb 2007 14:08:33 -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.174]) by postgresql.org (Postfix) with ESMTP id 108C39FB518 for ; Mon, 12 Feb 2007 14:08:31 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so1330101ugf for ; Mon, 12 Feb 2007 10:08:27 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=iGnlzoAm2ErZux02xq+venpp7jO/WM5A21xbcdDLiV3jG8NUEW/r9GuUz9oQVymDz4gw843knV7l8Q03ZRDcUsWBRdAFq7Ota+k6abZaUh/9pQpoJ79gXc7kzCKMREIj2bRH4aUJp08zku7eDLpgLGDU8oPcTiQ+IpezIaT4A1Y= Received: by 10.67.19.20 with SMTP id w20mr15380679ugi.1171303707122; Mon, 12 Feb 2007 10:08:27 -0800 (PST) Received: by 10.66.217.13 with HTTP; Mon, 12 Feb 2007 10:08:27 -0800 (PST) Message-ID: <55c095e90702121008u6d3d27c0m16e52d63f97c3e7d@mail.gmail.com> Date: Mon, 12 Feb 2007 15:08:27 -0300 From: "Ezequias Rodrigues da Rocha" To: "Scott Marlowe" Subject: Re: Deadlock on transaction Cc: pgsql-sql@postgresql.org, pgsql-admin@postgresql.org In-Reply-To: <1171302488.3565.15.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_79541_20233163.1171303707042" References: <55c095e90702120943v2909044eo91445b0eda3958c7@mail.gmail.com> <1171302488.3565.15.camel@state.g2switchworks.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.483 tagged_above=0 required=5 tests=AWL, BAYES_50, HTML_30_40, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/159 X-Sequence-Number: 24624 ------=_Part_79541_20233163.1171303707042 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I mean really deadlock. Other transactions can't access the database until the main transaction is complete. A question: PostgreSQL doesn't permit multiple transactions concurrently ? Ezequias 2007/2/12, Scott Marlowe : > > On Mon, 2007-02-12 at 11:43, Ezequias Rodrigues da Rocha wrote: > > 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 ? > > Are sure that what you're speaking of is a deadlock? Or is it just a > stalled transaction while one one transaction waits for another to > complete? > > A true deadlock means that two transactions are stalled waiting for the > other to complete, and neither ever can complete, and they are > DEADlocked. > > If you've just got a problem where an update is stalling all the other > transactions, then give us a test case / example code of what's > happening. > > If you've got a real deadlock that postgresql isn't catching, that's a > much more serious problem. > --=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_79541_20233163.1171303707042 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I mean really deadlock. Other transactions can't access the database un= til the main transaction is complete. A question:

PostgreSQL doesn&#= 39;t permit multiple transactions concurrently ?

Ezequias

2007/2/12, Scott Ma= rlowe <smarlowe@g2switchwo= rks.com>:
On Mon, 2007-02-12 at 11:43, Ezequias Rodrigues da Rocha wrote:
> 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) numb= ers of records
> 70,000 records.
>
> Could someone help me with it ?
Are sure that what you're speaking of is a deadlock?  Or= is it just a
stalled transaction while one one transaction waits for an= other to
complete?

A true deadlock means that two transactions are stalle= d waiting for the
other to complete, and neither ever can complete, and = they are
DEADlocked.

If you've just got a problem where an up= date is stalling all the other
transactions, then give us a test case / example code of what's
= happening.

If you've got a real deadlock that postgresql isn'= ;t catching, that's a
much more serious problem.



--
=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
        =             &nb= sp;            =  Atenciosamente (Sincerely)
      &nb= sp;            =      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<= br>The worst of democracies is still better than the better of dictatorship= s
http://ezequiasrocha.blo= gspot.com/ ------=_Part_79541_20233163.1171303707042--