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

From Brett Schwarz
Subject Re: Please help - tks
Date
Msg-id 20011018093149.3e1245af.brett_schwarz@yahoo.com
Whole thread Raw
In response to Please help - tks  (Mr OCP <mr_ocp@yahoo.com>)
Responses Re: Please help - tks
List pgsql-admin
A quick and dirty solution would be something like (untested):

while read line; do
    psql dbname -c "update table  ... use 'line' as your id and data"
    sleep 5
done < filename

where "filename" is the file with the ids in it. "dbname" is the name of your DB (of course!)

I am not sure what your file looks like, but you can do something like this. It could be easy, or harder, depending on
whatyour file has. 

adjust the sleep to your own specs.

--brett


P.S.

You could test this out by doing:

while read line; do
    psql dbname -c "select * from table where id=$line"
    sleep 5
done < filename



On Thu, 18 Oct 2001 16:35:01 +1000 (EST)
Mr OCP <mr_ocp@yahoo.com> 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
>
> http://briefcase.yahoo.com.au - Yahoo! Briefcase
> - Manage your files online.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Mirroring with WAL?
Next
From: Dmitry Morozovsky
Date:
Subject: Re: update in rule