Skip to main content
Question

PostgreSQL\data\base占用空间大

  • March 16, 2026
  • 2 comments
  • 19 views
G

1、veeam备份文件集到tape，postgreSQL\data\base\16398文件夹占用100GB空间。

2、在offline上的A磁带操作remove from catalog，发现在remove的时候，postgreSQL的数据量还在疯狂增长。（C盘可用20G，remove到一半时可用为0G。）

 

Q：如何解决remove catalog时数据量的增长？

      postgreSQL的占用空间是否有问题？（100GB）以前用veritas BE，数据库也没那么大占用空间啊。

    2 comments

    Jason Orchard-ingram micro
    Forum|alt.badge.img+2

    Summary of Fixes Inside Veeam
     

    • Disable tape file indexing unless required.
    • Remove old catalog entries in small batches.
    • Move VBRCatalog to a larger drive.
    • Reduce catalog retention settings.
    • Run Veeam’s internal DB cleanup tools.
    • Split operations to avoid DB overload.
    • Ensure auto-maintenance is active.
    • Contact Veeam Support for script‑based DB cleanup if the DB is heavily bloated.
       

      Open a Veeam Support Case and request the “Database vacuum/full maintenance procedure” performed by support scripts.
      These are safe, signed, and Veeam‑approved tools—not manual SQL commands.

      This is required when:

    • DB is >100 GB
    • Remove-from-catalog jobs exhaust disk space
    • Catalog entries number in the tens of millions
    G
    • goldensesh
    • Author
    • New Here
    • March 20, 2026

    Summary of Fixes Inside Veeam
     

    • Disable tape file indexing unless required.
    • Remove old catalog entries in small batches.
    • Move VBRCatalog to a larger drive.
    • Reduce catalog retention settings.
    • Run Veeam’s internal DB cleanup tools.
    • Split operations to avoid DB overload.
    • Ensure auto-maintenance is active.
    • Contact Veeam Support for script‑based DB cleanup if the DB is heavily bloated.
       

      Open a Veeam Support Case and request the “Database vacuum/full maintenance procedure” performed by support scripts.
      These are safe, signed, and Veeam‑approved tools—not manual SQL commands.

      This is required when:

    • DB is >100 GB
    • Remove-from-catalog jobs exhaust disk space
    • Catalog entries number in the tens of millions

    · How to Disable tape file indexing unless required？
    · Remove old catalog entries in small batches --> Database vacuum -- >

      PostgreSQL\Data\Base FreeSpace 88G-->78G

    · Reduce catalog retention settings. -- > four weeks

    · Run Veeam’s internal DB cleanup tools. -- > No tools

    · Ensure auto-maintenance is active. -- > How to check this option?

    Terms & ConditionsAccessibility statement