> > > 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?
No. Maybe Vadim does.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
