Postgres Pro
Downloads
Home   >   mailing lists

Thread: What about this?

What about this?

From
Wei Weng
Date:
Why can't postmaster run VACUUM ANALYZE automatically every once in a
while? Since it is a very useful feature...


-- 
Wei Weng
Network Software Engineer
KenCast Inc.

Re: What about this?

From
Josh Berkus
Date:
Wei,

> Why can't postmaster run VACUUM ANALYZE automatically every once in a
> while? Since it is a very useful feature...

Because such a practice is not appropriate for everyone's database
installation, that's why.

--
-Josh BerkusAglio Database SolutionsSan Francisco

Re: What about this?

From
Tom Lane
Date:
Josh Berkus <josh@agliodbs.com> writes:
>> Why can't postmaster run VACUUM ANALYZE automatically every once in a
>> while? Since it is a very useful feature...

> Because such a practice is not appropriate for everyone's database 
> installation, that's why.

No, the correct answer is "read the TODO list"...
        regards, tom lane

Re: What about this?

From
"Christopher Kings-Lynne"
Date:
That's what your crontab is for.

Chris

----- Original Message ----- 
From: "Wei Weng" <wweng@kencast.com>
To: <pgsql-sql@postgresql.org>
Sent: Saturday, August 03, 2002 5:40 AM
Subject: [SQL] What about this?


> Why can't postmaster run VACUUM ANALYZE automatically every once in a
> while? Since it is a very useful feature...
> 
> 
> -- 
> Wei Weng
> Network Software Engineer
> KenCast Inc.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
>