Re: Commit every N rows in PL/pgsql - Mailing list pgsql-general

From Len Walter
Subject Re: Commit every N rows in PL/pgsql
Date
Msg-id AANLkTilqlVO2bOkNFtlil4n4P8X-wpVmlgsxIppstzU3@mail.gmail.com
Whole thread Raw
In response to Re: Commit every N rows in PL/pgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

> ...
>     AfterTriggerEvents: 2642403328 total in 327 blocks; 10176 free (319
> chunks); 2642393152 used

And there's the problem.  Evidently you have an AFTER trigger on the
table, and the queued events for that trigger are overrunning memory.

That's interesting - I don't know of any triggers on this table, but it does have a lot of foreign key constraints. Would they fall into the same category?
 
--
len.walter@gmail.com skype:lenwalter  msn:len.walter@gmail.com

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: c program fails to run with the postgres which is installed at user location
Next
From: "J. Bagg"
Date:
Subject: Re: libreadline and Debian 5 - not missing just badly named