Postgres Pro
Downloads
Home   >   mailing lists

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

From Frank van Vugt
Subject Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?
Date
Msg-id 200408172333.42561.ftm.van.vugt@foxi.nl
Whole thread Raw
List pgsql-performance
Tree view 
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 by date:

Previous
From: Frank van Vugt
Date:
Subject: Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?
Next
From: Josh Berkus
Date:
Subject: Re: Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?