Re: How to optimize PostgreSQL database size

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to optimize PostgreSQL database size
Date: 2006-06-19 03:47:34
Message-ID: e756ou$g5i$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


""Linux Portal"" <linportal(at)gmail(dot)com> wrote
> The article on the subject can be read here:
>
> http://linux.inet.hr/optimize_postgresql_database_size.html
>

After dump/restore the database size is 1685 MB and after
vacuum-full/reindex is 1990 MB. Where we saved 305 MB?

Regards,
Qingqing

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-06-19 03:48:35 Re: Adding foreign key constraints without integrity check?
Previous Message Wes 2006-06-19 03:41:04 Adding foreign key constraints without integrity check?