Re: Excessive memory used for INSERT

From: Alessandro Ipe
Subject: Re: Excessive memory used for INSERT
Date: ,
Msg-id: 6645627.5dTte5MPLk@snow.oma.be
(view: Whole thread, Raw)
In response to: Re: Excessive memory used for INSERT  (Tom Lane)
Responses: Re: Excessive memory used for INSERT  (Alessandro Ipe)
List: pgsql-performance

Tree view

Excessive memory used for INSERT  (Alessandro Ipe, )
 Re: Excessive memory used for INSERT  (Torsten Zuehlsdorff, )
  Re: Excessive memory used for INSERT  (Tom Lane, )
   Re: Excessive memory used for INSERT  (Alessandro Ipe, )
    Re: Excessive memory used for INSERT  (Tom Lane, )
     Re: Excessive memory used for INSERT  (Alessandro Ipe, )
      Re: Excessive memory used for INSERT  (Alessandro Ipe, )
       Re: Excessive memory used for INSERT  (Tom Lane, )
        Re: Excessive memory used for INSERT  (Alessandro Ipe, )
        Re: Excessive memory used for INSERT  (Alessandro Ipe, )
         Re: Excessive memory used for INSERT  (Tom Lane, )
          Re: Excessive memory used for INSERT  (Alessandro Ipe, )
  Re: Excessive memory used for INSERT  (Alessandro Ipe, )
 Re: Excessive memory used for INSERT  (Torsten Förtsch, )
  Re: Excessive memory used for INSERT  (Alessandro Ipe, )

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 <> 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




pgsql-performance by date:

From: Robert DiFalco
Date:
Subject: Question about trigram GIST index
From: Tom Lane
Date:
Subject: Re: Question about trigram GIST index