Performance Concern - Database Migration Latency

I'm testing out different managed Postgres hosting solutions (from my dev machine but I've tried from a hosted server too.) and I'm experiencing unexpectedly slow execution times for create table queries, which is impacting my development workflow. Key Details: - Operation Type: Create table migrations - Observed Performance: Substantially longer execution times than anticipated I would appreciate your insights on: - Whether this is a known performance characteristic of your platform Potential optimization strategies or best practices Could you provide guidance on how to improve migration speed or explain the underlying factors contributing to the current latency?
No description
3 Replies
LogicSatinn
LogicSatinnOP4d ago
Here's a photo of the connection details, just incase.
No description
cmck
cmck3d ago
Hi there, thanks for reaching out. Looking at your workspace, I can see that you're on the free tier. This kind of performance is expected when using a shared cluster on the free tier. Under the hood, free tier branches are placed on a shared aurora cluster, and some parsing of users and schemas (owners and branches) is done in the backend that contributes to latency. If you're on a cluster with lots of branches, this can slow things down further. There aren't any best practices I can point you to to improve this performance on the free tier. Using a dedicated cluster on the Pro tier should improve performance, but naturally at increased cost which mightn't meet your needs.
LogicSatinn
LogicSatinnOP3d ago
Thank you for the reply
Want results from more Discord servers?
Add your server