From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
---|---|
To: | Craig James <cjames(at)emolecules(dot)com> |
Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(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 00:14:29 |
Message-ID: | CD852478-540E-4C37-ADCE-CCE99F145BF9@elevated-dev.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Aug 24, 2016, at 6:09 PM, Craig James <cjames(at)emolecules(dot)com> wrote:
>
> Right, I understand that the WAL has to record the operation. But I'm not sure that answers the question. If the contents of the WAL are, "copy this table to that table in index order", then no data from the table itself will be in the WAL. On the other hand, if the contents of the WAL are "create a new table, and then insert all of this data", then the WAL records will be huge.
>
> Which is it?
WAL records changes at the page level, not commands; so it will be the one you don't want.
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice
From | Date | Subject | |
---|---|---|---|
Next Message | Poul Kristensen | 2016-08-25 07:26:06 | Re: tools to centralize postgreSQL account management |
Previous Message | Craig James | 2016-08-25 00:09:11 | Re: Does CLUSTER generate WAL data? |