[GENERAL] When does CLUSTER occur?

[Schnabel, Robert D.]

Hi,

I'm looking for some general info on the behavior of CLUSTER.  I add large 
amounts of data to an existing table something like this:

BEGIN;
DROP INDEX IF EXISTS xgen1011_si_sn;
COMMIT;

BEGIN;
INSERT INTO gen1011
[snip]
COMMIT;

BEGIN;
CREATE INDEX xgen1011_si_sn
  ON gen1011
  USING btree
  (sample_id, snp_number)
  WITH (FILLFACTOR=100)
TABLESPACE index_tablespace;
ALTER TABLE gen1011 CLUSTER ON xgen1011_si_sn;
COMMIT;

My question is whether or not the "ALTER TABLE gen1011 CLUSTER ON 
xgen1011_si_sn" actually clusters the table at that point or if it just tells 
it to use that index for clustering?  If the latter I assume I need to add a 
"CLUSTER gen1011 ON xgen1011_si_sn" line at the end along with an ANALYSE line?

Thanks,
Bob