From: | "Grembowicz, Kenneth" <GrembowiczK(at)NAVO(dot)NAVY(dot)MIL> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
Subject: | VERY SLOW UPDATES |
Date: | 2000-08-18 13:55:09 |
Message-ID: | 23E4371F6124D411B59B00805F9FA971B185AC@navont3.navo.navy.mil |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This is my situation...
My table has about 1.6 million records.
I am trying to use the update command to insert new data.
However, it is extremely slow--about 2 to 4 seconds per update.
You can see my problem is I am trying to update 40,000 records.
Any insight or suggestion would be appreciated.
-Ken
PS I am currently wrapping my updates in a transaction block and indexes
have been dropped.
______________________________________________________
Kenneth P. Grembowicz
Oceanographic Databases Division, Code N51
Naval Oceanographic Office
1002 Balch Blvd.
Stennis Space Center, MS 39522-5001
Tel: (228) 688-5675
Fax: (228) 688-5778
e-mail: grembowiczk(at)navo(dot)navy(dot)mil
From | Date | Subject | |
---|---|---|---|
Next Message | Sevo Stille | 2000-08-18 14:07:21 | Re: Renaming database |
Previous Message | Thomas Lockhart | 2000-08-18 13:44:34 | Re: [HACKERS] [Fwd: Optimization in C] |