| From: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
|---|---|
| To: | akp geek <akpgeek(at)gmail(dot)com> |
| Cc: | Richard Huxton <dev(at)archonet(dot)com>, Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: FSM and VM file |
| Date: | 2010-03-03 13:53:43 |
| Message-ID: | 1267624423.9589.17.camel@hp-laptop2.gunduz.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2010-03-03 at 08:32 -0500, akp geek wrote:
> Thank you all for the suggestions. I did a vacuum and the size has
> gone down drastically. But still it is not the same size as my master.
> I am looking into it
Plain vacuum does not file system size of relations. It just marks dead
spaces are writable. If you haven't vacuumed for a long time, it
probably means that you have lots of space to be reused.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2010-03-03 14:25:29 | Re: [GENERAL] to_timestamp() and quarters |
| Previous Message | Richard Huxton | 2010-03-03 13:37:09 | Re: FSM and VM file |