Shaun M. Thomas: The Cache that Wasn’t: Optimizing Postgres for SELECT Performance
原文英文，约1900词，阅读约需7分钟。发表于：。Everyone has a cache for database results, right? Something like redis or memcached to prevent unnecessary and comparatively slow calls to the database. No? Worry not, for with Postgres and some trigger magic, we can produce a cache where there was none before. Don’t let complicated and expensive queries limit your application throughput when you really need to put the pedal to the metal. Let us show you how! [Continue reading...]
本文讨论了Postgres和客户端应用程序之间缺乏明确缓存的问题，介绍了使用材料化视图和触发器创建类似缓存的表来提高查询性能的方法。通过实验验证了使用触发器的查询性能明显提高，并强调Postgres提供了实现这种方法的工具。
