From: | "Schnabel, Robert D(dot)" <schnabelr(at)missouri(dot)edu> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | When does CLUSTER occur? |
Date: | 2012-11-29 16:11:44 |
Message-ID: | C20A71F48B88EF419C0DC4A55149844628035C@UM-MBX-N03.um.umsystem.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Kelly | 2012-11-29 16:15:42 | Re: When does CLUSTER occur? |
Previous Message | Peter Kroon | 2012-11-29 16:01:25 | set value var via execute |