Postgres Pro
Downloads
Home   >   mailing lists

Re: tables getting bloated - Mailing list pgsql-general

From akp geek
Subject Re: tables getting bloated
Date
Msg-id 2024a9fb1003180648h1b9a2f96j6346bbdccae7c690@mail.gmail.com
Whole thread Raw
In response to Re: tables getting bloated  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses Re: tables getting bloated  (Vick Khera <vivek@khera.org>)
Re: tables getting bloated  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view
I have job that does the vacuum full every day for those 2 tables and also for the database. By the end of the day, the get bloated. 

Regards

2010/3/18 Devrim GÜNDÜZ <devrim@gunduz.org>
On Thu, 2010-03-18 at 09:35 -0400, akp geek wrote:
>   I have been doing vacuum full on the database. A

Why? VF does not help you to get rid of bloat -- actually it will create
more bloat.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: tables getting bloated
Next
From: elekis
Date:
Subject: compile a program witn libpq64 (error LIBCMT.Lib...)