Know your gear
PSQL v12 database files can be defragmented without any engine down time. Reads and writes can operate continuously during defragmentation. The Defragmenter GUI will detect data files in use and can analyze fragmentation levels of files, allowing users to quickly find the biggest problem first. The online defragmentation feature can be launched from PCC. Check out a summary of this feature in the Defragmenter Datasheet. More details are available in the Monitoring Section of the PSQL v12 Advanced Operations Guide.