Re: UPDATE and DELEte with a lot of register is to slow... - Mailing list pgsql-sql

From John Dizaro
Subject Re: UPDATE and DELEte with a lot of register is to slow...
Date
Msg-id 11c2d5210811210434x153a20c0j95c01ebbaecaf70a@mail.gmail.com
Whole thread Raw
In response to UPDATE and DELEte with a lot of register is to slow...  ("John Dizaro" <jedsoftware@gmail.com>)
List pgsql-sql
 The problem is ...<br /><div dir="ltr" id="result_box" style="text-align: left;"><div dir="ltr" id="result_box"
style="text-align:left;">how to run the SCRIPT to the few? <br />not all the 50000 lines of "update" at the same
time.<br/> John Evan Dizaro<br /></div></div><br /><br /><div class="gmail_quote">2008/11/20 John Dizaro <span
dir="ltr"><<ahref="mailto:jedsoftware@gmail.com">jedsoftware@gmail.com</a>></span><br /><blockquote
class="gmail_quote"style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> I
have  to execute some times an UPDATE  an some times a DELETE  to register +- 50000  , every time when i do that  the
database be  to slow <br />do we any way to DELETE or UPDATE by part???<br />Thanks<br clear="all" /><font
color="#888888"><br/> -- <br /> John Evan Dizaro  - <br /><br /><br /></font></blockquote></div><br /><br clear="all"
/><br/>-- <br />John Evan Dizaro Software - <br />Fone: (41) 3333-0303<br />Fone: (41) 9243-3240<br />Rua: Alferes Poli
Curitiba- PR - Brasil<br /> 

pgsql-sql by date:

Previous
From: paulo matadr
Date:
Subject: Res: UPDATE and DELEte with a lot of register is to slow...
Next
From: "Paul Dam"
Date:
Subject: BULK COLLECT