Re: WAL replay of truncate fails if the table was dropped

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

In response to

Browse pgsql-bugs by date

  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