Payload slow with postgress

[mrwebninja]

I'm trying out Payload CMS 3 and have set up two projects:

Payload with MongoDB Atlas (free tier)

Payload with NeonDB PostgreSQL (free tier)

I noticed that Payload is significantly slower with PostgreSQL compared to MongoDB. As I read earlier, Payload initially supported only MongoDB and recently added support for PostgreSQL, so I think the development team might have more expertise with MongoDB and might take more time to improve PostgreSQL support.

Can anyone explain the exact reason why Payload is slow with PostgreSQL?

I need to develop an e-commerce app for virtual products (tickets). Which database would be better to use with Payload: PostgreSQL or MongoDB?

[2bad2furious]

For me a huge boost was to have the db close to the actual server. In my case I was using fly.io for app and supabase for db, moving db to fly was a huge boost. Where are you serving your app from?