postgres clustering interactions with pg_dump - Mailing list pgsql-performance

From Fitch, Britt
Subject postgres clustering interactions with pg_dump
Date
Msg-id A2DF436EDE1D2B4B9A8FE131CCC3CC9219661C4C6F@MAIL.corp.telenav.com
Whole thread Raw
Responses Re: postgres clustering interactions with pg_dump  (Robert Haas <robertmhaas@gmail.com>)
List 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

 

pgsql-performance by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Performance of CLUSTER
Next
From: Mark Thornton
Date:
Subject: Re: Performance of CLUSTER