From: | akp geek <akpgeek(at)gmail(dot)com> |
---|---|
To: | Devrim GÜNDÜZ <devrim(at)gunduz(dot)org> |
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 14:44:07 |
Message-ID: | 2024a9fb1003030644r650a9e32r997059f3c32cd715@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I just made changes to postgresql.conf to make sure the autovacuum is turned
on and I will update you.. Again thanks for your time
Regards
2010/3/3 Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
> 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 | Terry | 2010-03-03 14:49:51 | finding duplicate numbers in a select distinct statement |
Previous Message | Merlin Moncure | 2010-03-03 14:29:21 | Re: How to grant a user read-only access to a database? |