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

    Unanswered: Postgres free space problem


    I am new in PostgreSQL and I did the following. I removed around 3 out of 5 million records from one table and then I did vacuum analyze, then I checked that table in pg admin the estimate row count was 13 million instead of 2 millions that it must be. Why is that? I did this records removal to free up some space but instead my space was limited even more. What can I do to overcome this problem?

    Thanks in advance

  2. #2
    Join Date
    Apr 2010
    This should not happen. Strange to me also...Just connect to Database using SQL Pane of PgAdmin Or Using psql, then execute the

    select count(*) from <tablename>;

    Also, re-verify the data you have deleted are existing or not.

    It may be possible that while you were deleting data, there must be someone/user would be adding data in relation.

  3. #3
    Join Date
    Jun 2004
    Arizona, USA
    A trigger or rule, maybe?
    "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

Posting Permissions

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