Any stats on how much of a load this puts on the existing app?
Could this send to redis or a delayed job and be eventually consistent to database for non-logged in users?
Could this send to redis or a delayed job and be eventually consistent to database for non-logged in users?
I haven't benchmarked it specifically but I'd have to guess your time savings to store the information in a postgresql job queue vs the visits table would be negligible at best.