slow update & index question
| От | Williams, Travis L, NPONS |
|---|---|
| Тема | slow update & index question |
| Дата | |
| Msg-id | AB815D267EC31A4693CC24D234F8291602B03100@ACCLUST02EVS1.ugd.att.com обсуждение исходный текст |
| Ответы |
Re: slow update & index question
Re: slow update & index question |
| Список | 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 informationwas gotten from. Each line is tab seperated and consists of a column name and the value that it should be updateto. 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 matterin this case? Travis
В списке pgsql-general по дате отправления: