When does CLUSTER occur?

["Schnabel, Robert D." <schnabelr@xxxxxxxxxxxx>]

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