Tell me what PostgreSQL is doing in production.

A short description is enough to start. I will tell you whether a bounded investigation fits, then we agree on scope and timing before any paid work.