From: Frank van Vugt <ftm.van.vugt@foxi.nl>
To: pgsql-performance@postgresql.org
Subject: Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?
Date: Tue, 17 Aug 2004 23:33:42 +0200
Message-ID: <200408172333.42561.ftm.van.vugt@foxi.nl> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ftm.van.vugt@foxi.nl
Subject: Re: Why is the number of dead tuples causing the performance of deferred triggers to degrading so rapidly (exponentionally)?
In-Reply-To: <200408172333.42561.ftm.van.vugt@foxi.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox