Postgres Pro
Downloads
Home   >   mailing lists

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

From Craig James
Subject Does CLUSTER generate WAL data?
Date
Msg-id CAFwQ8reeHN+Cvy9TboYpthvGb+MwTRq_0Drg4KM==qP_hztXvw@mail.gmail.com
Whole thread Raw
Responses Re: Does CLUSTER generate WAL data?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Does CLUSTER generate WAL data?  (jaime soler <jaime.soler@gmail.com>)
List pgsql-admin
Tree view
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?

Thanks,
Craig

pgsql-admin by date:

Previous
From: koffi BADOH
Date:
Subject: tools to centralize postgreSQL account management
Next
From: "David G. Johnston"
Date:
Subject: Re: Does CLUSTER generate WAL data?