Re: [PERFORM] postgres clustering interactions with pg_dump

2012-07-23 Thread Robert Haas
On Mon, Jun 11, 2012 at 9:55 AM, Fitch, Britt wrote: > 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 p

[PERFORM] postgres clustering interactions with pg_dump

2012-06-11 Thread Fitch, Britt
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 per