From: Alessandro Ipe <Alessandro.Ipe@meteo.be>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Torsten Zuehlsdorff <mailinglists@toco-domains.de>,
 pgsql-performance@postgresql.org
Subject: Re: Excessive memory used for INSERT
Date: Thu, 18 Dec 2014 12:16:49 +0100
Message-ID: <6645627.5dTte5MPLk@snow.oma.be>
Organization: Royal Meteorological Institute of Belgium
User-Agent: KMail/4.14.3 (Linux/3.7.10-1.1-desktop; KDE/4.14.3; x86_64; ; )
In-Reply-To: <4171.1418838543@sss.pgh.pa.us>
References: <2163931.4eVnXNjHa3@snow.oma.be> <3672040.FVo2HxYOvt@snow.oma.be>
 <4171.1418838543@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Transfer-Encoding: 7Bit
Content-Type: text/plain; charset="iso-8859-15"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hi,


A grep in a  nightly dump of this database did not return any AFTER trigger.
The only keys are primary on each daily table, through
ADD CONSTRAINT "MSG_YYYY-MM-DD_pkey" PRIMARY KEY (slot, msg);
and on the global table
ADD CONSTRAINT msg_pkey PRIMARY KEY (slot, msg);


Regards,


A.


On Wednesday 17 December 2014 12:49:03 Tom Lane wrote:
> Alessandro Ipe <Alessandro.Ipe@meteo.be> writes:
> > My dtrigger definition is
> > CREATE TRIGGER msg_trigger BEFORE INSERT ON msg FOR EACH ROW EXECUTE
> > PROCEDURE msg_function(); so it seems that it is a BEFORE trigger.
> 
> Hm, no AFTER triggers anywhere?  Are there foreign keys, perhaps?
> 
> 			regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance