Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007

    Question Unanswered: Tunning EnterpriseDB( for disk space


    As i keep inserting and deleting the data, my Enterprise DB ( folder size is getting increased exponentially.

    We suspect that it might be because of transaction logs.

    Can some one help in tunning the Enterprise DB for disk space.

    Also can help what sort of information will be present in the location "C:\EnterpriseDB\\data\base"


  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    I believe you'll need to look at vacuuming your databases.

    PostgreSQL (on which EnterpriseDB is based) has a feature called autovaccuum, which will periodically perform a background vacuum. This releases rows which were previously deleted, for re-use. However, you still need to perform full vacuums periodically. A full vacuum is equivalent to a disk defrag. Deleted rows are removed and wasted space is recovered.
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert

  3. #3
    Join Date
    Mar 2006

    about base

    The base directory is the main place that contains your data for tables/indexes etc. The base directory contains per database directories (named on pg_database.oid). So, the directory titled 1 belongs to template1 and there is another directory for template0. Rest of the directories map to the oids of the databases that you create. Inside each of these directories, you would find different files (named on the pg_class.relfilenode) corresponding to the tables/indexes within that database. For more details and a timely response, you can register on the EnterpriseDB website and post your queries on the forums under the Support tab.

    A. Hayee Bhatti

Posting Permissions

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