New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Can you suggest specs for this app?
Hello,
I'm starting a simple app but I want to spend the least amount (as a starting point) so I'm looking for a LEB.
This app will have a map and will perform on the server just (the rest will use supabase) queries on my PostgreSQL database of 700k rows. It will use ST_MakeEnvelope() with coordinates with small boxes, like 5x5km each and I expect about 10-20 results for each query.
I now expecting about 1000 users daily doing 10 requests each, so 10k requests per day. That is if the app is actually used, so a best case scenario, otherwise it'll be much less.
I currently have one VPS with 1CPU Intel(R) Xeon(R) CPU E3-1246 v3 @ 3.50GHz and 500MB of RAM.
Do you think it could handle it without significant slowdowns?
Comments
I guess 500mb of ram is a typo
500mb ram? Why? Ram is cheap nowadays... Get moar.
It's not, it's what already had from years ago.
Given your VPS specifications and the expected load, it might be a bit challenging to handle 10,000 requests per day without significant slowdowns. The Intel Xeon E3-1246 v3 is a decent processor, but 500MB of RAM is quite low for handling that many requests, especially if your queries are complex.
You might experience performance issues, particularly during peak usage times. It could be beneficial to consider upgrading your VPS to one with more RAM (at least 2-4GB) to ensure smoother performance. I am guessing here. I no longer buy anything under 4GB so I don’t get banned for fair share abuse. Buy compute from major provider if you want more tolerance or design / VDS. If you see all queries come in within a few hours vs over 24 hours, think about the load during those times.
PostgreSQL is disk-heavy, especially when handling large queries. If you're on a slower disk (like an HDD), that could affect performance, but this isn't as much of an issue if you're using an SSD.
Again, heavy consistent usage on a VPS may bring attention from the host on their fair use policies, just be aware of RAM and CPU usage. I hear storage is dedicated. Cheap oversold servers are usually on older hardware too from my experience.
Definition of slowdown is relative. Some people are ok with waiting a little. Others are not. I don’t care for Nonprod as much. It’s called the overnight automation shift.
You definitely need more RAM
I think more than 2gb