Re: Does CLUSTER generate WAL data? - Mailing list pgsql-admin

From jaime soler
Subject Re: Does CLUSTER generate WAL data?
Date
Msg-id 1472114217.9541.37.camel@gmail.com
Whole thread Raw
In response to Does CLUSTER generate WAL data?  (Craig James <cjames@emolecules.com>)
List pgsql-admin
El mié, 24-08-2016 a las 16:06 -0700, Craig James escribió:
I know the CLUSTER command essentially creates a new table, copies the data in INDEX order, then deletes the original table.

Does that mean all of the data passes through the WAL logs, or is it purely an internal operation? More specifically, if we're doing streaming replication, will all of the data for the table being clustered be transmitted across the network to the hot-standby slave?

Yes for sure.

Thanks,
Craig

pgsql-admin by date:

Previous
From: jaime soler
Date:
Subject: Re: fe_sendauth: no password supplied - PostgreSQL 9.2
Next
From: leo
Date:
Subject: how to find correct command parameter of pg_resetxlog (9.4.5)