On Thu, 18 Oct 2001, [iso-8859-1] Mr OCP wrote: > Hi Folks > > 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. > > Do you guys have any script which may update records > one by one using the file that lists these records. I > am running postgresql sever under Unix, any kind of > script would do, whether its a perl, bash or sql > whatever script > > Thanks for your help > Mike
On the really Q&D, can you split (man split) your ID file into a few pieces, PG COPY this to temp tables (say 10 or 20), and use these smaller tables for your updates? -- Joel BURTON | [EMAIL PROTECTED] | joelburton.com | aim: wjoelburton Independent Knowledge Management Consultant ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
