What are common pitfalls when scaling Postgres indexing?

Context: I'm working on open source 053 and ran into a decision point.

• What I’ve tried: basic setup + quick benchmarks.
• Constraints: limited time, want something stable.

Question: What are common pitfalls when scaling Postgres indexing?

Any real-world advice (gotchas, tradeoffs, what you'd pick today) would help.