请问HN：我是一名新的PostgreSQL开发者 – 你们在使用Postgres时遇到过哪些问题？
嗨，HN，
我是一名开发者，正在深入研究PostgreSQL的内部结构，旨在为该项目做出有意义的贡献。我对核心组件有很强的理解，包括内部架构、物理复制、WAL（预写日志）和缓冲区管理。目前，我正在扩展到逻辑复制、异步I/O（AIO）、优化器等领域。
为了学习和成长为一名Postgres黑客，我希望直接听到你们——PostgreSQL用户——所面临的问题，无论大小。这些问题可能是操作上的挑战、性能瓶颈、令人困惑的行为、缺失的功能，或者是你们工作流程中的摩擦点。
对我来说，这是一种双赢的局面：你们得到一个试图解决实际问题的贡献者，而我则通过处理现实世界中重要的问题来加深自己的理解。如果某个问题引起我的共鸣，我会尽力进行调查、学习，并可能创建一个补丁来解决它。
谢谢，我期待听到你们的反馈！
查看原文
Hi HN,<p>I'm a developer diving deep into PostgreSQL internals, aiming to contribute meaningfully to the project. I have a strong grasp of core components like the internal architecture, physical replication, WAL (Write-Ahead Logging), and buffer management. I'm now expanding into areas like logical replication, asynchronous I/O (AIO), the optimizer, and beyond.<p>To learn and grow as a Postgres hacker, I want to hear directly from you—PostgreSQL users—about the problems you face, big or small. These could be operational challenges, performance bottlenecks, confusing behaviors, missing features, or friction points in your workflows.<p>For me, it's a win-win: you get a contributor trying to tackle real problems, and I get to deepen my understanding by working on issues that matter in the real world. If a problem resonates with me, I’ll do my best to investigate, learn, and potentially create a patch to address it.<p>Thanks—and I look forward to hearing from you!