postgres clustering interactions with pg_dump

From: "Fitch, Britt" <brittf(at)telenav(dot)com>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: postgres clustering interactions with pg_dump
Date: 2012-06-11 13:55:29
Message-ID: A2DF436EDE1D2B4B9A8FE131CCC3CC9219661C4C6F@MAIL.corp.telenav.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi, I have a table that I am clustering on an index.
I am then dumping that table via pg_dump -Fc and loading it into another database via pg_restore.
It is unclear to me though if the clustering I did in the original database is preserved during the dump & restore or if I would still need to perform a CLUSTER again once the data was loaded into the new database.

Can anyone confirm this?

Cheers,

Britt

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Thornton 2012-06-11 14:02:23 Re: Performance of CLUSTER
Previous Message Shaun Thomas 2012-06-11 13:42:52 Re: Performance of CLUSTER