Re: simple question

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.