Postgres Pro
Downloads
Home   >   mailing lists

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

From Jim Nasby
Subject Re: How to optimize PostgreSQL database size
Date
Msg-id 31F92A9B-2EEE-450D-BEBF-7BB6CA175099@pervasive.com
Whole thread Raw
In response to Re: How to optimize PostgreSQL database size  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Responses Re: How to optimize PostgreSQL database size
List pgsql-general
Tree view 
On Jun 18, 2006, at 10:47 PM, Qingqing Zhou wrote:
> ""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?

My guess would be due to toasted text columns... does VACUUM FULL
know to vacuum the toast tables only after committing the vacuum on
the base heap?
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: OT: publicly available databases?
Next
From: Jim Nasby
Date:
Subject: Re: How to build with bigger WAL segment file?