On Sun, Jul 19, 2009 at 08:56:08PM -0400, Robert James wrote: > Thanks, Chris. Is there a way to do this deterministically, or at least > programatically? I have code to create the tables and cluster them > automatically?
As Chris said, the index used by the primary key uses the table name with "_pkey" append on the end. If you want to figure out how psql is figuring this out, you can pass it -E when you connect. Why do you care though? CLUSTERing is a rather limited fix for a rather specialized type of problem, it's not something that's worth setting for every table and almost certainly not just blindly doing it on the table's primary key. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
