Re: How to optimize PostgreSQL database size
| От | Jim Nasby |
|---|---|
| Тема | Re: How to optimize PostgreSQL database size |
| Дата | |
| Msg-id | 31F92A9B-2EEE-450D-BEBF-7BB6CA175099@pervasive.com обсуждение исходный текст |
| Ответ на | Re: How to optimize PostgreSQL database size ("Qingqing Zhou" <zhouqq@cs.toronto.edu>) |
| Ответы |
Re: How to optimize PostgreSQL database size
|
| Список | pgsql-general |
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 по дате отправления: