许多人误解Postgres中的checkpoint_timeout，认为延长超时时间会导致崩溃后的恢复时间更长。实际上，恢复时间取决于需要重放的WAL记录数量，而非checkpoint_timeout的设置。频繁的检查点会增加写入压力，导致性能下降。建议将checkpoint_timeout设置在15到30分钟之间，以确保检查点由max_wal_size触发，而非超时。

Why do we still waste time browsing YouTube and news sites looking for interesting content? Why rely on someone else's algorithm — when Claude, for instance, retains conversation history in one...

The Night When Things Almost Went Down Have you ever left for home on a Friday evening feeling confident about your work for the day, at peace knowing your system would survive the coming...

In the previous post, we discussed the basic syntax of graph queries in PostgreSQL 19 and discussed some simple SQL/PGQ examples. However, more often than not applications are more complex and...

AI agents are becoming increasingly capable at operational tasks: summarizing logs, analyzing query plans, identifying anomalies, and assisting with incident response. For databases in particular,...

PostgreSQL today looks very different from the PostgreSQL many of us started working with over 25 years ago. PostgreSQL was once primarily deployed on dedicated servers and virtual machines,...

Postgres的pg_stats用于生成统计信息，帮助查询规划器优化执行计划。通过ANALYZE命令更新统计数据，pg_stats提供列的独特值、常见值及其频率等信息。准确的统计数据对查询性能至关重要，错误的统计会导致不佳的执行计划。使用相关统计可以提高多列过滤的准确性。

Recently, I looked into how common polymorphic associations actually are in relational databases — a performance-hostile pattern built around a discriminated foreign key that ORMs (Rails, Django,...

在PGDay France上，作者分享了评估Postgres扩展的方法，强调阅读源代码和理解逻辑的重要性。她指出，管理者应给予团队自由时间以促进成长，并分析了pgsql_tweaks扩展中的pg_bloat_info视图，解释如何识别数据库中的冗余空间。作者鼓励开发者利用时间学习和探索，以提升技能。