Re: Reducing the memory footprint of large sets of pending triggers
От | Simon Riggs |
---|---|
Тема | Re: Reducing the memory footprint of large sets of pending triggers |
Дата | |
Msg-id | 1224938179.15085.80.camel@ebony.2ndQuadrant обсуждение исходный текст |
Ответ на | Reducing the memory footprint of large sets of pending triggers (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Reducing the memory footprint of large sets of pending triggers
|
Список | pgsql-hackers |
On Thu, 2008-10-23 at 21:32 -0400, Tom Lane wrote: > We've occasionally talked about allowing pending-trigger-event lists to > spill to disk when there get to be so many events that it's a memory > problem. I'm not especially interested in doing that right now, but > I noticed recently that we could alleviate the problem a lot by adopting > a more compact representation. This change goes in the right direction, whereas the spill to disk probably doesn't, except for certain cases. A much better objective would be to remove duplicate trigger calls, so there isn't any build up of trigger data in the first place. That would apply only to immutable functions. RI checks certainly fall into that category. I mention this now in case you have a bright idea about how to do that quickly and cheaply. Otherwise I'll be looking into that in the next dev cycle. -- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support
В списке pgsql-hackers по дате отправления: