How do you choose between Postgres and FAISS for newsletter curation?

Context: I'm working on model optimization 098 and ran into a decision point.

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

Question: How do you choose between Postgres and FAISS for newsletter curation?

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