Re: Does CLUSTER generate WAL data?

From: jaime soler <jaime(dot)soler(at)gmail(dot)com>
To: Craig James <cjames(at)emolecules(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Does CLUSTER generate WAL data?
Date: 2016-08-25 08:36:57
Message-ID: 1472114217.9541.37.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
> >

>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message leo 2016-08-29 03:35:21 how to find correct command parameter of pg_resetxlog (9.4.5)
Previous Message jaime soler 2016-08-25 08:33:43 Re: fe_sendauth: no password supplied - PostgreSQL 9.2