So this is not inside a trigger but on the app connected to pg?

Yes, per the article they “scaled” Postgres to meet their requirements by altering their usage pattern to avoid hitting the bottleneck.