I’m curious if anyone can speak to what the limiting factors are on BAM’s ability to process notifications? We’ve experienced some occurrences where it looks like the notification processing has hit a SQL block for a period of time, causing PNA file backlogs on the BAM. Once the block clears, it takes BAM a certain amount of time to catch back up. Observing the appliance while it does so, it seems a single postmaster process CPU-bound against a single thread - so depending on the size of the backlog it can take quite a bit of time to catch up, even though the BAM overall is 98% idle.
This notification processing is really the only performance-related concern I currently have for our BAMs - and it would be awesome if notification processing could be improved in such a way as to better consume the available hardware resources.