Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2

Dear Achilleus,

Dunno, it's a multiuser environment. However, I'll try asking everyone to
stop working for a minute...

... oops, I just see that it finished about half an hour before (taking an
amazing 76 minutes for ALTER TABLE to complete). About that time, I started
and exited a client. Seems it solved the problem. Now "vacuum full analyze"
finished in a couple of seconds.

Do you have any idea about an explanation? Does vacuum wait for the end of
each and every transaction?

G.
--
while (!asleep()) sheep++;

---------------------------- cut here ------------------------------
----- Original Message -----
From: "Achilleus Mantzios" <achill@matrix.gatewaynet.com>
Sent: Tuesday, May 06, 2003 7:53 PM


Maybe its a locking issue.

Did you quit any app using the DB?
Did you commit/rollback all pending transactions (if any)?