Re: UPDATE and DELEte with a lot of register is to slow...

From: "John Dizaro" <jedsoftware(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: UPDATE and DELEte with a lot of register is to slow...
Date: 2008-11-21 12:34:25
Message-ID: 11c2d5210811210434x153a20c0j95c01ebbaecaf70a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmail(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Paul Dam 2008-11-21 13:20:50 BULK COLLECT
Previous Message paulo matadr 2008-11-20 19:04:08 Res: UPDATE and DELEte with a lot of register is to slow...