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

From David G. Johnston
Subject Re: Does CLUSTER generate WAL data?
Date
Msg-id CAKFQuwZ-s2s1VJwjKdTo8RygvpKSYOhthViCoN=HP7TK3FJ7tQ@mail.gmail.com
Whole thread Raw
In response to Does CLUSTER generate WAL data?  (Craig James <cjames@emolecules.com>)
Responses Re: Does CLUSTER generate WAL data?
List pgsql-admin
On Wed, Aug 24, 2016 at 7:06 PM, Craig James <cjames@emolecules.com> wrote:
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?


Not looking at the code but, yes, the replica must be an exact physical duplicate of the master and since the only ongoing source of data for the replica is the WAL the actions taken as part of performing a CLUSTER must be logged.

David J.

pgsql-admin by date:

Previous
From: Craig James
Date:
Subject: Does CLUSTER generate WAL data?
Next
From: Craig James
Date:
Subject: Re: Does CLUSTER generate WAL data?