Skip site navigation (1) Skip section navigation (2)

Re: Very slow UPDATEs... (Solution found!)

From: Dmitri Touretsky <dmitri(at)listsoft(dot)ru>
To: Dmitri Touretsky <dmitri(at)listsoft(dot)ru>
Cc: PostgreSQL Novice Mailing List <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Very slow UPDATEs... (Solution found!)
Date: 2003-01-25 13:44:20
Message-ID: 2425124787.20030125164420@listsoft.ru (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)listsoft(dot)ru )

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


In response to

pgsql-novice by date

Next:From: Desmond CoughlanDate: 2003-01-25 13:52:00
Subject: Re: Can't read input file
Previous:From: Dmitri TouretskyDate: 2003-01-25 11:59:14
Subject: Very slow UPDATEs...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group