VCS/PostgreSQL prevent dead lock during read acl update

SQL "TRUNCATE" command requires an exclusive lock that can lead to db dead lock, NXP-4557:removes most of the truncate usage during read acl update, .
There is still one possible truncate during acl update to flush a cache, this must be done at the end of the transaction to prevent holding the lock too long.