Postgres Pro
Downloads
Home   >   mailing lists

Re: How to optimize PostgreSQL database size - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: How to optimize PostgreSQL database size
Date
Msg-id e756ou$g5i$1@news.hub.org
Whole thread Raw
In response to How to optimize PostgreSQL database size  ("Linux Portal" <linportal@gmail.com>)
Responses Re: How to optimize PostgreSQL database size
List pgsql-general
Tree view 
""Linux Portal"" <linportal@gmail.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

pgsql-general by date:

Previous
From: Wes
Date:
Subject: Adding foreign key constraints without integrity check?
Next
From: Tom Lane
Date:
Subject: Re: Adding foreign key constraints without integrity check?