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
|
Список | 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 по дате отправления: