VACUUM VERBOSE ANALYZE locking up?? Please help! - Mailing list pgsql-sql

<p><font size="2">Ok it doesn't kill the whole backend, but VACUUM... comes</font><br /><font size="2">to a halt
partwaythrough and it's necessary to ^C out</font><br /><font size="2">of the transaction in psql.  Sometimes trying
againwill</font><br /><font size="2">work, mostly that doesn't work.  Restarting the backend</font><br /><font
size="2">andthen doing the VACUUM... will usually result in</font><br /><font size="2">success.  I was having this
problemin 7.0.something and</font><br /><font size="2">it's still happening in 7.1.3 (built from scratch on a</font><br
/><fontsize="2">Redhat 6.2 box).  I used pg_dumpall to migrate the data.</font><br /><font size="2">I've made a serious
effortto hunt the web for a clue with no</font><br /><font size="2">real success.</font><p><font size="2">Here's what I
get:</font><p><fontsize="2">cwilkins=# vacuum verbose analyze;</font><br /><font size="2">NOTICE:  --Relation
pg_type--</font><br/><font size="2">NOTICE:  Pages 4: Changed 0, reaped 1, Empty 0, New 0; Tup 244: Vac 0,</font><br
/><fontsize="2">Keep/VTL 0/0, Crash 0, UnUsed 26, MinLen 106, MaxLen 109; Re-using:</font><br /><font
size="2">Free/Avail.Space 4472/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u</font><br /><font size="2">sec.</font><br
/><fontsize="2">NOTICE:  Index pg_type_oid_index: Pages 2; Tuples 244: Deleted 0. CPU</font><br /><font
size="2">0.00s/0.00usec.</font><br /><font size="2">NOTICE:  Index pg_type_typname_index: Pages 4; Tuples 244: Deleted
0.</font><br/><font size="2">CPU 0.00s/0.00u sec.</font><br /><font size="2">NOTICE:  Analyzing...</font><br /><font
size="2">NOTICE: --Relation pg_attribute--</font><br /><font size="2">NOTICE:  Rel pg_attribute: TID 24/20:
DeleteTransactionInProgress0 -</font><br /><font size="2">can't shrink relation</font><br /><font size="2">NOTICE:  Rel
pg_attribute:TID 24/21: DeleteTransactionInProgress 0 -</font><br /><font size="2">can't shrink relation</font><br
/><fontsize="2">NOTICE:  Rel pg_attribute: TID 24/22: DeleteTransactionInProgress 0 -</font><br /><font size="2">can't
shrinkrelation</font><br /><font size="2">NOTICE:  Rel pg_attribute: TID 24/23: DeleteTransactionInProgress 0
-</font><br/><font size="2">can't shrink relation</font><br /><font size="2">NOTICE:  Rel pg_attribute: TID 24/24:
DeleteTransactionInProgress0 -</font><br /><font size="2">can't shrink relation</font><br /><font size="2">NOTICE:  Rel
pg_attribute:TID 24/25: DeleteTransactionInProgress 0 -</font><br /><font size="2">can't shrink relation</font><br
/><fontsize="2">[[[etc... etc...  snip...]]]</font><br /><font size="2">NOTICE:  Index pg_rewrite_oid_index: Pages 2;
Tuples11: Deleted 0. CPU</font><br /><font size="2">0.00s/0.00u sec.</font><br /><font size="2">NOTICE:  Index
pg_rewrite_rulename_index:Pages 2; Tuples 11: Deleted 0.</font><br /><font size="2">CPU 0.00s/0.00u sec.</font><br
/><fontsize="2">NOTICE:  --Relation pg_toast_17058--</font><br /><font size="2">NOTICE:  Pages 1: Changed 0, reaped 1,
Empty0, New 0; Tup 2: Vac 0,</font><br /><font size="2">Keep/VTL 0/0, Crash 0, UnUsed 3, MinLen 834, MaxLen 2034;
Re-using:</font><br/><font size="2">Free/Avail. Space 5280/0; EndEmpty/Avail. Pages 0/0. CPU 0.01s/0.00u</font><br
/><fontsize="2">sec.</font><br /><font size="2">NOTICE:  Index pg_toast_17058_idx: Pages 2; Tuples 2: Deleted 0.
CPU</font><br/><font size="2">0.00s/0.00u sec.</font><br /><font size="2">[[[query stops here and will go no
further]]]</font><p><fontsize="2">Any useful insights or solutions?  Pretty please?  :)</font><p><font size="2">Thanks
forany help,</font><br />                        <font size="2">Charlie</font><p><font size="2">(Apologies in advance
ifthis message has any HTML component.</font><br /><font size="2">I've told ^%$#@! Outlook as loudly as possible PLAIN
TEXTONLY!)</font><br /><font size="2">--</font><br /><font size="2">Charlie Wilkinson</font><br /><font size="2">TRIS
DevelopmentSystems Administrator</font><br /><font size="2">M:I:SD:CT:CC:TD</font><br /><font size="2">Phone:
202-283-3241</font><br/><font size="2">MSMail:   Charlie.E.Wilkinson@irs.gov</font><br /><font size="2">SMTP: 
cwilkins@tris.irs.gov</font><br/><font size="2">Home:  cwilkins@boinklabs.com</font><br /><font size="2">This message
constructedfrom 90% post-consumer electrons. </font>