Re: Large table update/vacuum PLEASE HELP!

Tom Jenkins wrote:

>
>Just to be sure we all understand, you ran
>  vacuum analyze;
>
>you didn't just run vacuum or vacuum full
>
>the analyze part is important; it creates statistics for the query
>planner
>
Well... NO. I just did vacuum, not analyze (I was hoping to save the
'analyze ' part till after I create the indexes).

I don't think that statistics matters for this particular query plan,
which is nothing but 'seq scan on a'...
And it does come up with the correct plan (as if it had much choice
anyway :-), despite missing statistics...

I'll try to do 'analyze' (after my vacuum full finishes sometime
tomorrow) though, but doubt it will make any difference (unless, I am
missing something important in my inderstanding of the meaning of 'analyze')

Thanks!

Dima