| From: | Alessandro Ipe <Alessandro(dot)Ipe(at)meteo(dot)be> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Torsten Zuehlsdorff <mailinglists(at)toco-domains(dot)de>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Excessive memory used for INSERT |
| Date: | 2014-12-18 11:16:49 |
| Message-ID: | 6645627.5dTte5MPLk@snow.oma.be |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(dot)Ipe(at)meteo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alessandro Ipe | 2014-12-18 15:42:23 | Re: Excessive memory used for INSERT |
| Previous Message | Torsten Förtsch | 2014-12-18 07:51:47 | Re: Excessive memory used for INSERT |