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?
3 Replies
Here's a photo of the connection details, just incase.
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.
Thank you for the reply