Too much time to delete 19000 rows
От | Ezequias Rodrigues da Rocha |
---|---|
Тема | Too much time to delete 19000 rows |
Дата | |
Msg-id | 55c095e90610061110t5a3040c3pec05bd2c413a85dd@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Too much time to delete 19000 rows
Re: Too much time to delete 19000 rows |
Список | pgsql-sql |
Hi list,<br /><br />I am having many problems to delete a table with only 19000 rows.<br /><br />The selection takes lessthan 1 second but on delete I wait more 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="font-weight: bold;" /><pre class="PROGRAMLISTING"><spanstyle="font-weight: bold;">BEGIN WORK;</span><br style="font-weight: bold;" /><span style="font-weight:bold;"> delete from base.ticket where session_id = 17 and cash_id = 99 and promo_id = 5;</span><br style="font-weight: bold;" /><spanstyle="font-weight: bold;">COMMIT WORK; </span><br /><br />I just think it could be occuring becouse of many constraints(7 at all) <br /></pre><br />Please any help is welcomed.<br /><br />Regards<br />Ezequias<br clear="all" /><br />-- <br /> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br /> Atenciosamente(Sincerely) <br /> Ezequias Rodrigues da Rocha<br/> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br />A pior das democracias ainda é melhordo que a melhor das ditaduras<br />The worst of democracies is still better than the better of dictatorships <br /><ahref="http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blogspot.com/</a>
В списке pgsql-sql по дате отправления: