News for hackers. Stuff that matters.
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.

There are no comments on this comment yet.