Message-ID: <1472114217.9541.37.camel@gmail.com>
Subject: Re: Does CLUSTER generate WAL data?
From: jaime soler <jaime.soler@gmail.com>
Reply-To: jaime.soler@gmail.com
To: Craig James <cjames@emolecules.com>, "pgsql-admin@postgresql.org"
	 <pgsql-admin@postgresql.org>
Date: Thu, 25 Aug 2016 10:36:57 +0200
In-Reply-To: 
 <CAFwQ8reeHN+Cvy9TboYpthvGb+MwTRq_0Drg4KM==qP_hztXvw@mail.gmail.com>
References: 
	<CAFwQ8reeHN+Cvy9TboYpthvGb+MwTRq_0Drg4KM==qP_hztXvw@mail.gmail.com>
Content-Type: multipart/alternative; boundary="=-b3o5JBIcWU6P++0nCIx9"
Mime-Version: 1.0
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


--=-b3o5JBIcWU6P++0nCIx9
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit

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
> > 

> 

--=-b3o5JBIcWU6P++0nCIx9
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 8bit

<html><head></head><body><div>El mié, 24-08-2016 a las 16:06 -0700, Craig James escribió:</div><blockquote type="cite"><div dir="ltr"><div>I know the CLUSTER command essentially creates a new table, copies the data in INDEX order, then deletes the original table.</div><div><br></div><div>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?</div></div></blockquote><div><br></div><div>Yes for sure.</div><blockquote type="cite"><div dir="ltr"><div><br></div><div>Thanks,</div><div>Craig</div><div><br></div>
</div>
</blockquote></body></html>
--=-b3o5JBIcWU6P++0nCIx9--