Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Dedicated for PostgreSQL 64G+ SSD/NVMe wanted $60 max
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.

Dedicated for PostgreSQL 64G+ SSD/NVMe wanted $60 max

flashgunflashgun Member
edited January 2020 in Requests

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

  • DPDP Administrator, The Domain Guy

    That’s a beefy one.

    Hetzner may be the best choice but it’s also worth checking out SyS and Ikoula.

  • jsgjsg Member, Resident Benchmarker

    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.

    Thanked by 2flashgun Hetzner_OL
  • 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 :)

    Thanked by 2flashgun kp93
  • @angelius said:
    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.

  • MrRadicMrRadic Patron Provider, Veteran

    Hetzner is your best bet.

    Thanked by 2flashgun Hetzner_OL
  • mustafamw3mustafamw3 Member, Patron Provider

    Check Webtropia.com

    Thanked by 1flashgun
  • @flashgun said:

    @angelius said:
    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.

    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)

    Thanked by 1flashgun
  • ServerHunterServerHunter Member, Host Rep

    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. :)

    Thanked by 2flashgun Hetzner_OL
  • jsgjsg Member, Resident Benchmarker

    @flashgun said:
    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.

    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.

    Thanked by 1flashgun
  • @noaman said:

    Basically its an advanced key value store mostly used for caching

    Its great if most of your usage is read only queries

    So that's not my case. I have up to 700 rows written per second.

  • spectraipspectraip Member, Patron Provider
    edited January 2020

    @flashgun said:
    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.

    Do you need more cores or higher clock rate? Please let me know!

  • jsgjsg Member, Resident Benchmarker

    @flashgun said:

    @noaman said:

    Basically its an advanced key value store mostly used for caching

    Its great if most of your usage is read only queries

    So that's not my case. I have up to 700 rows written per second.

    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.

Sign In or Register to comment.