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.
Dmitri Touretsky ( dmitri(at)listsoft(dot)ru )
New SOFT daily (RUS): http://www.listsoft.ru/
Friends come and go. Enemies are forever.
In response to
pgsql-novice by date
|Next:||From: Desmond Coughlan||Date: 2003-01-25 13:52:00|
|Subject: Re: Can't read input file|
|Previous:||From: Dmitri Touretsky||Date: 2003-01-25 11:59:14|
|Subject: Very slow UPDATEs...|