Re: Loss of cluster status

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Loss of cluster status
Date: 2003-02-23 10:52:33
Message-ID: 20030223185149.Q3637-100000@houston.familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> >> Would it be an idea to issue a CLUSTER command after the CREATE TABLE
> >> statement in SQL dumps for tables that have an indisclustered index?
>
> Yeah...

<snip>

> A CLUSTER command issued just after table creation, while it's
still
> empty, would be cheap ... but we don't put the index in place until
> we've loaded the data, do we? Darn.

CREATE CLUSTERED INDEX ...?

Chris

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ian Barwick 2003-02-23 10:55:56 Linking to "current" docs
Previous Message Tom Lane 2003-02-23 05:36:25 Re: pg_dump / restore of empty database gives errors