Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] Full support for index LP_DEAD hint bits on standby - Mailing list pgsql-hackers

From Michail Nikolaev
Subject Re: [PATCH] Full support for index LP_DEAD hint bits on standby
Date
Msg-id CANtu0oidssx49W5Vt1U1R=QCcUB7JfhCGzF9Z5FgvyLdJdweww@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Full support for index LP_DEAD hint bits on standby  (Michail Nikolaev <michail.nikolaev@gmail.com>)
List pgsql-hackers
Tree view 
UPD:

> I was thinking it is safe to have additional hint bits
> on primary, but it seems like no.

Oh, sorry for the mistake, it is about standby of course.

> BTW I am wondering if it is possible
> to achieve the same situation by pg_rewind and standby promotion…

Looks like it is impossible, because wal_log_hints is required in
order to use pg_rewind.
It is possible to achieve a situation with some additional LP_DEAD on
standby compared to the primary, but any change on primary would cause
FPI, so LP_DEAD will be cleared.

Thanks,
Michail.

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Corruption during WAL replay
Next
From: Robert Haas
Date:
Subject: Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations