Re: Slow Update

On Wed, Mar 09, 2005 at 11:44:33 -0300,
Ricardo Valença de Assis <valenca(at)campusvirtual(dot)br> wrote:
> Hi everydoby!
>
> I have a table with more than 26000 rows and I need to use update a
> column of this tables on all lines according with a column. So, I need to
> use update 26000 times correct? I tried to use a this command:
> "UPDATE database SET column1=0 WHERE column2 in (VARIABLES)", where
> VARIABLES is the list separeted by commas. But the list has about 26000
> entries, so I got a message of too long parameters. Is there a way to use
> UPDATE pushing values from a file? Is there a way to run update more faster?
> It is taking about 10 seconds for each UPDATE... Does anyone knows another
> form to do this task?

If you really want to do this for all rows in the table just do:
UPDATE tablename SET column1=0;

>
> ----- Original Message -----
> From: "Daniel Rubio" <drubior(at)tinet(dot)org>
> To: <pgsql-admin(at)postgresql(dot)org>
> Sent: Wednesday, March 09, 2005 8:33 AM
> Subject: Re: [ADMIN] Too many clients----A big problem for my team

Why did you include this message that had nothing to do with your question?