Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Orlando, FL
    Provided Answers: 1

    Question Unanswered: Track Tables Filling Disk

    I have a Firewall called Untangle and it uses a PostgreSQL database that logs all Firewall events. Sadly the system crashed because the database was full. It wrote 12+ GB's in a matter of days so my only option was to run the following command:

    DROP SCHEMA events cascade;
    This dumps everything in the 'events' schema and clears GB's of disk space so I can operate the machine again. My question is how in pgsql can I locate or determine once the system is full again, which table(s) are filling up? I don't know my way enough around SQL or Postgres to determine how or which tables or uses the most space or filling up. Sadly I can just clear it with the command posted above.

    Can anyone please guide or help me?

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 8
    Check out the PostgreSQL Wiki:

    Disk Usage - PostgreSQL wiki

  3. #3
    Join Date
    Mar 2011

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts