Howdy, Stranger!

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

Advertise on LowEndTalk.com
Dedicated for PostgreSQL 64G+ SSD/NVMe wanted $60 max
New on LowEndTalk? Please read our 'Community Rules' by clicking on it in the right menu!

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

flashgunflashgun Member
edited January 2 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

  • thedpthedp Member

    That’s a beefy one.

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

    Ongoing Domain Auctions: LET | LES
    Brandable IT/Hosting-related & Miscellaneous Domain Names For Sale!

  • jsgjsg Member

    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

    Thanks no.

  • 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 Member, Provider

    Hetzner is your best bet.

    Thanked by 2flashgun Hetzner_OL

    Servers UNDER $50 that aren't from 1999: ReliableSite Clearance Specials

  • Check Webtropia.com

    Thanked by 1flashgun
  • noamannoaman Member

    @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

    Easily browse and compare over 20,000+ servers from over 390 different providers: https://www.serverhunter.com/
    All pricing, specifications and stock is automatically updated. Use our Discord to get instant notifications when it's in stock.

  • jsgjsg Member

    @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

    Thanks no.

  • @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, Provider
    edited January 4

    @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

    @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.

    Thanks no.

Sign In or Register to comment.