> > Shouldn't vacuum analyze be ran when the indices are in place? I think the
> > indices tell vacuum analyze which fields are important for stats gathering?
> >
>
> stats are gathered on all fields.
Bruce,
Forgive the naive question but I just had to do a dump, table drop and
re-create and then a reload to get beyond the following stderr
which killed vacuum and created a stale lock:
NOTICE: BlowawayRelationBuffers(tx_plan, 4): block 4 is referenced (private 0, last
0, global 1)
FATAL 1: VACUUM (vc_rpfheap): BlowawayRelationBuffers returned -2
Can you tell me what this cryptic message means?
Thanks alot,
Tom
------- North Richmond Community Mental Health Center -------
Thomas Good MIS Coordinator, Senior DBA
Vital Signs: tomg@ { admin | q8 } .nrnet.org
Phone: 718-354-5528
Fax: 718-354-5056
/* Member: Computer Professionals For Social Responsibility */
