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 2024a9fb1003251009i51a12738h1b2f50a0e45b224b@mail.gmail.com
Whole thread Raw
In response to Re: tables getting bloated  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Tree view
Thanks for the help

2010/3/18 Craig Ringer <craig@postnewspapers.com.au>
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

pgsql-general by date:

Previous
From: tv@fuzzy.cz
Date:
Subject: Re: How many Mandatory Process are there in Postgres
Next
From: Scott Mead
Date:
Subject: Re: How many Mandatory Process are there in Postgres