does pg_restore respect CLUSTER ON in the schema?

Поиск
Список
Период
Сортировка
От Seth Pollack
Тема does pg_restore respect CLUSTER ON in the schema?
Дата
Msg-id 97FDAC87-2540-47B9-9F3C-00CA124F3D36@pollackphoto.com
обсуждение исходный текст
Ответы 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>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: Tablespace limit feature
Следующее
От: John R Pierce
Дата:
Сообщение: Re: does pg_restore respect CLUSTER ON in the schema?