SEO

#1 (**permalink**) 04-17-2008, 07:25 PM

Hi list,

I am using Postgresql version 8.1. It has been announced that in this version, autovacuum is no longer a seperate process and is integrated into postgres. However, I can't tell if my database has autovacuumed. I've turned on the configurations in the autovacuum section in postgresql.conf. What else should I do to make it happen?

TIA,
Hank

#2 (**permalink**) 04-17-2008, 07:25 PM

On Wed, May 17, 2006 at 05:04:56PM +0800, Hank Hsiung wrote:
> Hi list,
>
> I am using Postgresql version 8.1. It has been announced that in this version, autovacuum is no longer a seperate process and is integrated into postgres. However, I can't tell if my database has autovacuumed. I've turned on the configurations in the autovacuum section in postgresql.conf. What else should I do to make it happen?

If you look in your logs, you should see something like:
May 17 13:24:49 fritz postgres[13852]: [3-1] LOG: autovacuum: processing database "postgres"

Though, that probably depends on your logging settings.
--
Jim C. Nasby, Database Architect decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

autovacuum?