Re: preventing deadlocks

On Sun, Jan 08, 2006 at 10:57:21AM +0200, Tsirkin Evgeny wrote:
>
> Jim C. Nasby wrote:
>
> >Personally, I'd just put the effort into setting up the insert/delete
> >stuff and a means to periodically roll that info up into a summary
> >table. I know that this has come up in the past, so you can probably
> >find someone else who's already done this and might be able to provide
> >you with code. Even if you have to write it from scratch, I doubt it's
> >more work than what you've already put into trying to get the other
> >scheme to work.
> >
> Thanks.Do you think that using LISTEN/NOTIFY mechanism for rolling up
> the summary table
> could be used?

Sure, although on a busy system it might be better to just poll once a
minute or so. I'm not sure what the overhead for a NOTIFY is, but I
imagine it would start to add up if you were calling several times a
second.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461