Обсуждение: 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.

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

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

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
>