Re: [GENERAL] How to optimize PostgreSQL database size

2006-06-22 Thread Tom Lane
Jim Nasby <[EMAIL PROTECTED]> writes: > On Jun 18, 2006, at 10:47 PM, Qingqing Zhou wrote: >> 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... No, it's probably got more to do wit

Re: [GENERAL] How to optimize PostgreSQL database size

2006-06-22 Thread Jim Nasby
On Jun 18, 2006, at 10:47 PM, Qingqing Zhou wrote: ""Linux Portal"" <[EMAIL PROTECTED]> 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. W

Re: [GENERAL] How to optimize PostgreSQL database size

2006-06-18 Thread Qingqing Zhou
""Linux Portal"" <[EMAIL PROTECTED]> 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