Обсуждение: Extremely slow update

Hi all,

I executed a very simple update command: UPDATE spacked SET int_tipus=4;
The db parameters: cc. 67000 records, fresh vacuum analyze. And the
execution lasted for hours! (I don't know exactly how much, because in
the meanwhile I went to sleep :)  The only thing that could be affect
its speed is that I created this column with an ALTER TABLE ADD COLUMN...
command. Anyway, after it finished, a vacuum analyze command ran for more
than 12 hours, after that I killed it.

Is it normal, or something wrong?

postgresql 6.3.2, i486DX2-66, 16MB RAM.

Thx all:
Circum


 __  @
/  \    _   _                                           Engard Ferenc
l    | ( \ /  | | (\/)                      mailto:s-fery@kkt.sote.hu
\__/ | |   \_ \_/ I  I                    http://pons.sote.hu/~s-fery