From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
Cc: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, "PostgreSQL Bugs" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: WAL replay of truncate fails if the table was dropped |
Date: | 2007-07-20 18:06:30 |
Message-ID: | 11732.1184954790@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> If I understand this: the primary would be initialised yet the standby
> would remain uninitialised? I don't think that matters because the
> actual the data contents are still zero.
From a logical perspective the page is "empty" either way. The only
behavioral difference I can think of is that the initialized page is a
candidate for insertion of new tuples, whereas on the slave it would not
be a candidate until after another VACUUM. So the histories would
diverge faster once the slave comes alive. As long as the slave is just
following WAL records and not making any decisions of its own, I can't
see a failure mode; but it looks like a potential weak spot for future
extensions (particularly, trying to allow slave servers to execute
queries).
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Walter Roeland | 2007-07-21 04:54:24 | BUG #3476: description of root.crt/crl in documentation |
Previous Message | Simon Riggs | 2007-07-20 17:36:21 | Re: WAL replay of truncate fails if the table was dropped |