Re: Reindex "locked" standby database

> On 15 Dec 2021, at 00:52, Mladen Gogala <gogala(dot)mladen(at)gmail(dot)com> wrote:
>
> On 12/14/21 22:37, Michael Paquier wrote:
>> You are referring to the startup process that replays WAL, right?
>> Without having an idea about the type of workload your primary and/or
>> standbys are facing, as well as an idea of the configuration you are
>> using on both (hot_standby_feedback for one), I have no direct idea,
>> but that could be a conflict caused by a concurrent vacuum.
>
> Hi Michael,
>
> I am preparing for a standby deployment. I don't have a standby yet and, therefore, I don't have any standby problems. Would it be advisable to turn vacuum off on the standby? Applying WAL will also, in theory, populate the statistics which is also held in the database blocks.

Take this with grain of salt since I’m far from being an expert :) , just trying to help. To my knowledge, assuming you would be running a physical standby, vacuum operations wouldn’t run there, only in the primary. Changes would get propagated via physical replication to your standby (blocks that change due to vacuuming on the primary).

Hope that helps.

>
> Regards
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
>
>