Re: Please help - tks - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Please help - tks
Date
Msg-id Pine.LNX.4.30.0110182204150.633-100000@peter.localdomain
Whole thread Raw
In response to Please help - tks  (Mr OCP <mr_ocp@yahoo.com>)
List pgsql-admin
Mr OCP writes:

> We have about 300,000 records to update, I have created a file with
> the ids of the records to be updated, since the number of records to
> be updated is very large, the update statement takes forever and
> server slows down dramatically, therefore I want to do one at a time.

That's going to be *much* slower yet.  What's your point?

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: PgAccess on OS X--was "tcl wish--simple configure problem"
Next
From: Brian McCane
Date:
Subject: Re: delete/vacuum not freeing disk space