| From: | "Williams, Travis L, NPONS" <tlw(at)att(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | slow update & index question |
| Date: | 2002-10-21 18:22:44 |
| Message-ID: | AB815D267EC31A4693CC24D234F8291602B03100@ACCLUST02EVS1.ugd.att.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a script that is updating the DB by reading in a file with 467 lines. Each file is named by the shelf the information was gotten from. Each line is tab seperated and consists of a column name and the value that it should be update to. The update line in the perl script looks like this: update table set "column name" = 'value' where "Shelf_Name" = '$shelf'
Now this works.. but it takes almost 1 minute to do the updates. With nothing else at all touching the DB.. is this normal? The DB is index'd on the Shelf_Name column.. but how do I know if it is using the index.. or does that not even matter in this case?
Travis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | MT | 2002-10-21 18:33:03 | Can't write lock file |
| Previous Message | Robert Treat | 2002-10-21 18:17:47 | Re: [GENERAL] Security implications of (plpgsql) functions |