| 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: | Whole Thread | Raw Message | 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] |