Re: Commit every N rows in PL/pgsql

Поиск
Список
Период
Сортировка
От Len Walter
Тема Re: Commit every N rows in PL/pgsql
Дата
Msg-id AANLkTilqlVO2bOkNFtlil4n4P8X-wpVmlgsxIppstzU3@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Commit every N rows in PL/pgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: c program fails to run with the postgres which is installed at user location
Следующее
От: "J. Bagg"
Дата:
Сообщение: Re: libreadline and Debian 5 - not missing just badly named