Re: Buglist
От | Shridhar Daithankar |
---|---|
Тема | Re: Buglist |
Дата | |
Msg-id | 3F460965.10857.4CC821B@localhost обсуждение исходный текст |
Ответ на | Re: Buglist (Jan Wieck <JanWieck@Yahoo.com>) |
Ответы |
Re: Buglist
|
Список | pgsql-general |
On 21 Aug 2003 at 18:46, Jan Wieck wrote: > Manfred Koizar wrote: > > On Thu, 21 Aug 2003 21:10:34 +0530, "Shridhar Daithankar" > > <shridhar_daithankar@persistent.co.in> wrote: > >>Point I am trying to make is to tune FSM and autovacuum frequency > >>such that you catch all the dead tuples in RAM > > > > You might be able to catch the pages with dead tuples in RAM, but > > currently there's no way to keep VACUUM from reading in all the clean > > pages, which can be far more ... > > Which leads us to a zero gravity vacuum, that does the lazy vacuum for > pages currently available in the buffer cache only. And another pg_stat > column telling the number of tuples vacuumed so that an autovac has a > chance to avoid IO consuming vacuum runs for relations where 99% of the > dead tuples have been caught in memory. Since autovacuum issues vacuum analyze only, is it acceptable to say that this is taken care of already? Bye Shridhar -- "One size fits all": Doesn't fit anyone.
В списке pgsql-general по дате отправления: