Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 7 replies
  • Subscribers 2 subscribers
  • Views 11819 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Clean up PostgreSQL Database

GL@MO
Hi there,

is there a possibility to clean up my postgreSQL database without losing all data? (not the postgre rebuild-command [;)] )

I had some contact with Sophos support today which told me my db is about 4GB, too big.


This thread was automatically locked due to age.
Parents
  • 0
    To add to what Barry said, the vacuum command runs automatically in the AMs, so after you reduce your retention rates, you should see a reduction in DB size the next morning.  The shorter the retention rates, the more space you'll save.
Reply
  • 0
    To add to what Barry said, the vacuum command runs automatically in the AMs, so after you reduce your retention rates, you should see a reduction in DB size the next morning.  The shorter the retention rates, the more space you'll save.
Children
No Data