I'm using Postgresql and I have 2 data in table.
The id values of each of the two data are 1 and 5.
Please see the picture above.
I tried VACUUM but dead rows are not cleaned up.
I have already tried the following ways
- Check if there are running transactions (does not exist)
- Check
autovacuum = on - Check read and write permissions (have permission)
- Check if table is in use by another session
I've checked everything, but running VACUUM doesn't clear dead rows.
I don't know how to troubleshoot.