Re: Optimization

Поиск
Список
Период
Сортировка
От Peter Childs
Тема Re: Optimization
Дата
Msg-id Pine.LNX.4.44.0307290812420.511-100000@RedDragon.Childs
обсуждение исходный текст
Ответ на Re: Optimization  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Ответы Re: Optimization  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-performance
On Tue, 29 Jul 2003, Shridhar Daithankar wrote:

> On 28 Jul 2003 at 12:27, Josh Berkus wrote:
> > Unless you're running PostgreSQL 7.1 or earlier, you should be VACUUMing every
> > 10-15 minutes, not every 2-3 hours.   Regular VACUUM does not lock your
> > database.  You will also want to increase your FSM_relations so that VACUUM
> > is more effective/efficient; again, see the articles.
>
> There is an auto-vacuum daemon in contrib and if I understand it correctly, it
> is not getting much of a field testing. How about you guys installing it and
> trying it?

    If there is such a daemon, what is it called? As I can't see it.
Is it part of gborg?

Peter Childs


В списке pgsql-performance по дате отправления:

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Optimization
Следующее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Optimization