slow update & index question

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

Responses

Browse pgsql-general by date

  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