Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?

Поиск
Список
Период
Сортировка
От Frank van Vugt
Тема Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?
Дата
Msg-id 200408172333.42561.ftm.van.vugt@foxi.nl
обсуждение исходный текст
Список pgsql-performance
Obviously,

this part of tr_f_def():

******************************
        -- delete the contents
--        delete from f;
        IF EXISTS (SELECT 1 FROM f) THEN
            DELETE FROM F;
            VACUUM F;
        END IF;
******************************


should simply read:

******************************
        -- delete the contents
        delete from f;
******************************



--
Best,




Frank.


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

Предыдущее
От: Frank van Vugt
Дата:
Сообщение: Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?