Re: When does CLUSTER occur? - Mailing list pgsql-general

From Jeff Janes
Subject Re: When does CLUSTER occur?
Date
Msg-id CAMkU=1xY7h+QY7R_NDwJYOgR+s+s2=WLD9eLxY4dNF79v34OBw@mail.gmail.com
Whole thread Raw
In response to When does CLUSTER occur?  ("Schnabel, Robert D." <schnabelr@missouri.edu>)
Responses Re: When does CLUSTER occur?  (Mike Christensen <mike@kitchenpc.com>)
Re: When does CLUSTER occur?  ("Schnabel, Robert D." <schnabelr@missouri.edu>)
List pgsql-general
On Thu, Nov 29, 2012 at 8:11 AM, Schnabel, Robert D.
<schnabelr@missouri.edu> wrote:

> 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?

It just marks it to use that index if/when it is clustered, it doesn't
do the clustering.


Cheers,

Jeff


pgsql-general by date:

Previous
From: Peter Kroon
Date:
Subject: Re: set value var via execute
Next
From: Mike Christensen
Date:
Subject: Re: When does CLUSTER occur?