Обсуждение: Very slow UPDATEs...

Good time of the day!

I've run into a strange problem and have no idea what/where to look...
Will be happy to get any input...

Situation is: simple updates takes, say, 5 minutes to complete...
E.g. (from psql)
test=> UPDATE progs SET acc = 1 WHERE id = 4601;
UPDATE 1
Time: 346451,14 ms

"id" is indexed and EXPLAIN shows that index is used. "acc" is not
indexed, so there shouldn't be any slowdown. Table is relatively small
- like 15000 records. Table is vacuumed and analyzed.

Need ideas on what to check / what to read / where to look, etc.

Thanks in advance!

--
Best regards,
 Dmitri Touretsky ( dmitri@listsoft.ru )

New SOFT daily (RUS):  http://www.listsoft.ru/
               (ENG):  http://www.listsoft.com/
---
Allow me to introduce my selves.

Good time of the day!

DT> I've run into a strange problem and have no idea what/where to look...
DT> Will be happy to get any input...

DT> Situation is: simple updates takes, say, 5 minutes to complete...
DT> E.g. (from psql)
test=>> UPDATE progs SET acc = 1 WHERE id = 4601;
DT> UPDATE 1
DT> Time: 346451,14 ms

Well, right after sending this message I found solution. Reindex did
the job. Bad part is that there were no any warnings that indexes are
corrupted, even vacuum was displaying that everything is OK.

--
Best regards,
 Dmitri Touretsky ( dmitri@listsoft.ru )

New SOFT daily (RUS):  http://www.listsoft.ru/
               (ENG):  http://www.listsoft.com/
---
Friends come and go. Enemies are forever.