Re:Postgres 11 – A First Look
by blattimwind on Saturday September 22, 2018 @07:10AM
(#18045512)
> He used triggers to store the id of the most recent message of every conversation in another table. That is probably the most efficient solution in any database.
Depends on how often that last message query is run. If it's infrequent, the trigger is just write amplification.
Depends on how often that last message query is run. If it's infrequent, the trigger is just write amplification.