Обсуждение: tables getting bloated
Hi All -
I have been doing vacuum full on the database. Also I do vacuum these 2 tables. But there are 2 tables they are getting bloated like any thing. Just only 2 tables. Can you please suggest that I can do to tackle the issue. Appreciate your help
Regards
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
Вложения
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:Why? VF does not help you to get rid of bloat -- actually it will create
> I have been doing vacuum full on the database. A
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
2010/3/18 akp geek <akpgeek@gmail.com>: > 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. Do not run vacuum full. Run vacuum. For these two tables, run vacuum more often, as you clearly are updating it very frequently. You may want to investigate running autovacuum which will probably take care of this for you. For our big database, I run vacuum nightly on the whole thing, and let autovacuum run as well, to take care of the high-churn tables. I run the nightly just to keep the autovacuum from running during peak times on my larger tables which don't churn as much, but are speed sensitive.
On 18/03/2010 9:48 PM, akp geek wrote: > 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. http://wiki.postgresql.org/wiki/Introduction_to_VACUUM%2C_ANALYZE%2C_EXPLAIN%2C_and_COUNT http://wiki.postgresql.org/wiki/VACUUM_FULL -- Craig Ringer
Thanks for the help
2010/3/18 Craig Ringer <craig@postnewspapers.com.au>
On 18/03/2010 9:48 PM, akp geek wrote:http://wiki.postgresql.org/wiki/Introduction_to_VACUUM%2C_ANALYZE%2C_EXPLAIN%2C_and_COUNTI 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.
http://wiki.postgresql.org/wiki/VACUUM_FULL
--
Craig Ringer