On Mon, Aug 3, 2026 at 5:16 AM Andrey Borodin <[email protected]> wrote:
> I think swapping two SQL statements would be enough:
>
>  $node2->safe_psql('postgres', <<EOM);
> -SELECT pg_switch_wal();
>  CHECKPOINT;
> +SELECT pg_switch_wal();
>  EOM

Thanks to both of you for the analysis, and apologies for the slow
response. Here's a patch. I think the tricky part is justifying the
change, which I at least find counterintuitive (else I would have done
it right to begin with!). The attached patch attempts to explain via a
lengthy comment.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

Attachment: v1-0001-003_tli_switch.pl-Adjust-command-order-to-avoid-p.patch
Description: Binary data

Reply via email to