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: (view raw or whole 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> 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):
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-2015 The PostgreSQL Global Development Group