Skip to content

Examined + solution Block table to find a workflow to delete obsolte blocks, DB Pictures with pg Admin ERD Tool

Urbas Gerald requested to merge Block-storage-cleanup into main

The block table holds tons of orphaned rows. This is partly based on missing relations in prisma / commented out The other problem is the huge size, that normal operations block.

The Delete statement can be tuned with LIMIT, and is meant to be run multiple times.

Merge request reports

Loading