Re: tables getting bloated

[akp geek <akpgeek@xxxxxxxxx>]

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@xxxxxxxxxx>

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