Potential Issues with PayloadCMS on Vercel using PostgreSQL

[nathanbowang]

Hey everyone,

I'm planning to deploy my PayloadCMS project on Vercel with PostgreSQL as the database. Since Vercel functions run on AWS Lambda behind the scenes, I'm concerned about potential database connection issues.

My Setup

• PayloadCMS running on Vercel
• PostgreSQL database
• Vercel serverless functions (Lambda)

Main Concerns

1. Database Connection Exhaustion

Serverless functions spin up and down based on demand. Each function instance creates a new database connection. During traffic spikes, we might hit PostgreSQL's connection limits.

2. Connection Establishment Latency

Creating a new database connection takes time (100-500ms during cold starts). This could lead to slower response times, especially for admin panel operations.

3. Function Timeout Issues

Vercel functions have execution time limits. Complex database operations might get cut off before completion.

Has anyone deployed PayloadCMS on Vercel with PostgreSQL? Any issues or successful configurations to share?

Thanks in advance for any insights!