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 ...
how to run the SCRIPT to the few?
not all the 50000 lines of "update" at the same time.
John Evan Dizaro


2008/11/20 John Dizaro <jedsoftware@gmail.com>
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
do we any way to DELETE or UPDATE by part???
Thanks

--
John Evan Dizaro  -





--
John Evan Dizaro Software -
Fone: (41) 3333-0303
Fone: (41) 9243-3240
Rua: Alferes Poli Curitiba - PR - Brasil

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