Thanks for the help
2010/3/18 Craig Ringer
> 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_ANAL
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/
2010/3/18 akp geek :
> 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
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
> 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 h
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
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
