On Wed, 12 Nov 2003, Rick Gigger wrote:
> Is this correct?
>
> vacuum by itself just cleans out the old extraneous tuples so that they
> aren't in the way anymore
> vacuum analyze rebuilds indexes. If you add an index to a table it won't be
> used until you vacuum analyze it
> vacuum full actually compresses the table on disk by reclaiming the space
> from the old tuples after they have been removed.
You don't have to analyze AFTER index creation, just at some point in
time. I.e.:
create table test ...
import into table test 1000000 rows
analyze test;
create index test_field1_dx on test (id);
select * from test where id=4567; <- this will likely use the index.