Should I CLUSTER on PRIMARY KEY

From: Robert James <srobertjames(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Should I CLUSTER on PRIMARY KEY
Date: 2009-07-20 00:07:58
Message-ID: e09785e00907191707x602f2c7bk4ca172e8988afc76@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to CLUSTER a table on its PRIMARY KEY. Now, I haven't
explicitly defined and named an index for this table - but the primary key
defines one. How can I tell Postgres to CLUSTER on it?
Also: If I define an index on a PK, will Postgres make a second one, or
realize its redundnant?
Thanks!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2009-07-20 00:10:22 Re: Understanding sequential versus index scans.
Previous Message Dennis Gearon 2009-07-19 23:56:09 Re: timestamp with time zone tutorial