Postgres Pro
Downloads
Home   >   mailing lists

does pg_restore respect CLUSTER ON in the schema? - Mailing list pgsql-general

From Seth Pollack
Subject does pg_restore respect CLUSTER ON in the schema?
Date
Msg-id 97FDAC87-2540-47B9-9F3C-00CA124F3D36@pollackphoto.com
Whole thread Raw
Responses Re: does pg_restore respect CLUSTER ON in the schema?  (John R Pierce <pierce@hogranch.com>)
Re: does pg_restore respect CLUSTER ON in the schema?  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-general
Tree view 
I have a database where several tables have been physically clustered on disk. Those clustering configuration
parametersare stored in the schema (via ALTER TABLE mytable CLUSTER ON myindex). 

My question is, when i restore a backup of this database using pg_restore, is it restored with that physical
clustering,or without? i.e. do i need to run a cluster command immediately after the restore, or is it already done?  

Thanks,
Seth

pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Tablespace limit feature
Next
From: John R Pierce
Date:
Subject: Re: does pg_restore respect CLUSTER ON in the schema?