79455058

Date: 2025-02-20 15:48:30
Score: 1
Natty:
Report link

Thanks to all of the answers, at the end it seems that currently there's no way to disable the transactions + pipe-lining in the typical database clients (pgadmin4, dbevaver), so I resorted to use the command line for postgres reindex.

I converted the reindex queries to this:

reindexdb -v --concurrently -d alx -i public."l2016mgix"
reindexdb -v --concurrently -d alx -i public."l2017dhix"

With the added benefit that with the -v, I get a small duration report after each reindex has been done.

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: aseques