| From: | "SZUCS Gabor" <surrano(at)mailbox(dot)hu> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 |
| Date: | 2003-05-06 13:52:04 |
| Message-ID: | 008801c313d6$ad89e390$0a03a8c0@fejleszt2 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)matrix(dot)gatewaynet(dot)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)?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2003-05-06 13:56:18 | Re: Cast type int2vector/array_field to character |
| Previous Message | A.Bhuvaneswaran | 2003-05-06 13:36:23 | Re: pg_ ? |