From: | Patrick Hatcher <PHatcher(at)macys(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Vacuum hangs |
Date: | 2004-11-09 19:09:33 |
Message-ID: | OFCD60E586.D3B85401-ON88256F47.006521F4-88256F47.006A7D56@fds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
PG: 7.4.5
RH 7.3
Vac_Mem=12mg
Doing a Vacuum Analyze on a table and it's been hanging for at least 2
hours. I could see no other users hitting the table at the time. This is
the second time this has happened on this particular table and I can't
seem to pin point the issue. If I kill the PID and restart the vacuum
analyze it works fine. Any suggestion where I start searching? Here is
an output from pg_stat_activity and the
mdc_oz=# select * from pg_stat_activity:
datid | 17145
datname | mdc_oz
procpid | 16560
usesysid | 2
usename | phatcher
current_query | VACUUM ANALYZE cdm.cdm_reg_customer;
query_start | 2004-11-09 10:02:32.523146-08
mdc_oz=# select * from pg_locks where pid=16560;
-[ RECORD 1 ]-------------------------
relation | 7059380
database | 17145
transaction |
pid | 16560
mode | ShareUpdateExclusiveLock
granted | t
-[ RECORD 2 ]-------------------------
relation |
database |
transaction | 28863986
pid | 16560
mode | ExclusiveLock
granted | t
-[ RECORD 3 ]-------------------------
relation | 7059380
database | 17145
transaction |
pid | 16560
mode | ShareUpdateExclusiveLock
granted | t
TIA
Patrick Hatcher
From | Date | Subject | |
---|---|---|---|
Next Message | TJ Talluto | 2004-11-09 19:20:20 | need simple strategy for universal extension table |
Previous Message | Tom Lane | 2004-11-09 18:44:32 | Re: [GENERAL] server auto-restarts and ipcs |