Re: Loss of cluster status - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Loss of cluster status
Date
Msg-id 20030223185149.Q3637-100000@houston.familyhealth.com.au
Whole thread Raw
In response to Re: Loss of cluster status  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump / restore of empty database gives errors
Next
From: Ian Barwick
Date:
Subject: Linking to "current" docs