There is a server with postres 13 running out of disk space.
It contains a table
metrics that occupies 90% of the entire database.
I have deleted old records in this table.
Due to this table is used in production, I cannot run "VACUUM FULL metrics".
Since I can't afford to block it.
After deleting old records I want to
REINDEX CONCURRENTLY bloated indexes to free space.
But first of all I would like to know how much space is needed to reindex them. If the server runs out of space Postgres will crash.
So, is it possible to calculate a space requirement for REINDEX in Postgresql?