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.
Dedicated for PostgreSQL 64G+ SSD/NVMe wanted $60 max
Hi team,
after DignusData disappeared looking for the dedicated server for my pet-project. The load is pretty high: 700 tps or so.
Processor CPU Mark: 13000+
Memory: 64G+
SSD/NVMe: 512G+
Network: 15Tb+ on 1G port
Budget: $60 monthly or less
Location: any
Also need in custom partitioning of drive(s) because using ZFS with compression for DB/WAL files.
Currently the best offers are:
- EuServ Instant64 AR SSD v6 (47.60 euro + 53.55 installation fee + 4 weeks to wait for delivery)
- Hetzner AX41-NVMe for 39 euro + 39 euro setup fee + 20% taxes
Can anyone suggest something more interesting?
No mail/spam/scam/mining/adult and anything. Just database and some perl scripts collecting data from xbox live restful api.
Comments
That’s a beefy one.
Hetzner may be the best choice but it’s also worth checking out SyS and Ikoula.
AFAIK usually nobody beats Hetzner, but it's always worth to have a look at @ServerHunter's and at @Neoon's site.
Right now Hetzner auctions a Ryzen 1700 based dedi that meets your spec for less than €50 per month. Of course the usual caveats apply, e.g. make sure to verify what "unlimited" traffic means.
Implement some redis layer before your db and run this on a 5€ vm from hetzner (redis+pg), I do this for a pet project with 8000 tps
Sounds interesting. Have no expirience with Redis but found out it is in-memory db. My postgresql db size is 250G right now. 40 tables, 2 of them are 150m rows.
Hetzner is your best bet.
Check Webtropia.com
Basically its an advanced key value store mostly used for caching
Its great if most of your usage is read only queries
Otherwise it will be just a layer and eating resources of its own (even though very minimum)
Here are some of your options:
https://www.serverhunter.com/?search=C97-89B-21A
For some non-Hetzner options, take a look here:
https://www.serverhunter.com/?search=03F-5D2-5AE
As people mentioned, Hetzner offers the best value in this case.
Before offering any advice on optimization - which you didn't ask for - you should provide more info on your situation.
FWIW I have a hunch that your problem is not Postgresql but with your application and/or config.
So that's not my case. I have up to 700 rows written per second.
http://www.slideshare.net/GrantMcAlister/tuning-postgresql-for-high-write-throughput?from_m_app=android
Do you need more cores or higher clock rate? Please let me know!
Spread over how many tables? What size? Etc.
700 rows per second can be anything between a killer and virtually nothing, depending on lots of context and details.
A bigger server is almost certainly not the smart answer or only for some time.