Skip site navigation (1) Skip section navigation (2)

Vacuum Problems

From: "Rafael Domiciano" <rafael(dot)domiciano(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Vacuum Problems
Date: 2008-11-26 13:43:22
Message-ID: 3a0028490811260543x74d02719w775a457999cfc74@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi there,
I need some help or just some hints. I am having problems with vacuum full
in one table only: "clifatura".
That table has today around 7 million rows.

I scheduled on the server a cron job to run VACUUM FULL every day at 23 P.M,
but on the following day, at 8 A.M. vacuum is yet working on "clifatura"; so
I have to kill vacuum.

I read something about maintenance_work_mem, so I increased it to 128MB. My
server is a Intel Xeon Dual-Core 2.8 Ghz with 2 Gb RAM, running Postgres
8.2.4.

In others times recreating the table is Ok, but it can't be the right thing
to do.

I hope anyone have some information.

Thanks,

Rafael Domiciano

Responses

pgsql-admin by date

Next:From: Rafael MartinezDate: 2008-11-26 14:26:15
Subject: Re: Vacuum Problems
Previous:From: Jaume SabaterDate: 2008-11-26 08:39:05
Subject: Re: Best option for expanding beyond 1 pg server in this situation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group