Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id CFA949FB3FE
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  6 Oct 2006 15:10:06 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 96807-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  6 Oct 2006 15:10:04 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168])
	by postgresql.org (Postfix) with ESMTP id F2A829FB3BB
	for <pgsql-sql@postgresql.org>; Fri,  6 Oct 2006 15:10:03 -0300 (ADT)
Received: by ug-out-1314.google.com with SMTP id 30so358180ugc
	for <pgsql-sql@postgresql.org>; Fri, 06 Oct 2006 11:10:02 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=ANKZDjH60y4LXLzv93t8pq9cr6v9qTK21nJ29ZdzbciTtvfv6nKyw86hBChExLek/n7hVvy4INa6iyPLG5zueNkY7MoNeymJ9LslzNJ7bmWkC1XJYVi2X3Wk6koMnXRPT/0Y76999Ut6pcY/U7CdZ15BApxXfXSg1Bo+xsb1Rys=
Received: by 10.66.240.12 with SMTP id n12mr3537285ugh;
	Fri, 06 Oct 2006 11:10:02 -0700 (PDT)
Received: by 10.67.94.13 with HTTP; Fri, 6 Oct 2006 11:10:01 -0700 (PDT)
Message-ID: <55c095e90610061110t5a3040c3pec05bd2c413a85dd@mail.gmail.com>
Date: Fri, 6 Oct 2006 15:10:01 -0300
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Too much time to delete 19000 rows
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1637_23719833.1160158201813"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.696 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200610/83
X-Sequence-Number: 26472

------=_Part_1637_23719833.1160158201813
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi list,

I am having many problems to delete a table with only 19000 rows.

The selection takes less than 1 second but on delete I wait more than 4
minutes and notthing. Can someone tell me what could happen ?

I tryed only one transaction but it does not work too:

BEGIN WORK;
delete from base.ticket where session_id =3D 17 and cash_id =3D 99 and prom=
o_id =3D 5;
COMMIT WORK;

I just think it could be occuring becouse of many constraints (7 at all)


Please any help is welcomed.

Regards
Ezequias

--=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-=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_1637_23719833.1160158201813
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi list,<br><br>I am having many problems to delete a table with only 19000=
 rows.<br><br>The selection takes less than 1 second but on delete I wait m=
ore than 4 minutes and notthing. Can someone tell me what could happen ?
<br><br>I tryed only one transaction but it does not work too:<br><br style=
=3D"font-weight: bold;"><pre class=3D"PROGRAMLISTING"><span style=3D"font-w=
eight: bold;">BEGIN WORK;</span><br style=3D"font-weight: bold;"><span styl=
e=3D"font-weight: bold;">
delete from base.ticket where session_id =3D 17 and cash_id =3D 99 and prom=
o_id =3D 5;</span><br style=3D"font-weight: bold;"><span style=3D"font-weig=
ht: bold;">COMMIT WORK; </span><br><br>I just think it could be occuring be=
couse of many constraints (7 at all)
<br></pre><br>Please any help is welcomed.<br><br>Regards<br>Ezequias<br cl=
ear=3D"all"><br>-- <br> =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-<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;Atenciosamente (Sincerely)
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ez=
equias Rodrigues da Rocha<br> =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-<br>A pior das democracias ainda =E9 melhor do que=
 a melhor das ditaduras<br>The worst of democracies is still better than th=
e better of dictatorships
<br> <a href=3D"http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.bl=
ogspot.com/</a>

------=_Part_1637_23719833.1160158201813--