| From: | Dmitri Touretsky <dmitri(at)listsoft(dot)ru> |
|---|---|
| To: | PostgreSQL Novice Mailing List <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Very slow UPDATEs... |
| Date: | 2003-01-25 11:59:14 |
| Message-ID: | 1118819240.20030125145914@listsoft.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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(at)listsoft(dot)ru )
New SOFT daily (RUS): http://www.listsoft.ru/
(ENG): http://www.listsoft.com/
---
Allow me to introduce my selves.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitri Touretsky | 2003-01-25 13:44:20 | Re: Very slow UPDATEs... (Solution found!) |
| Previous Message | Desmond Coughlan | 2003-01-25 03:15:43 | Altering Column Date Types |