Howdy, Stranger!

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

Dedicated server for Postgresql database
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 server for Postgresql database

Hey guys :)

I have Hetzner server where i host only postgresql DB. i7 6700, 64gb, 2x ssd. Looks like CPU is startig to be bottleneck. I have no experience when it comes to CPUs for good database performance so what would you advise?
Hetzner i9 9900k
Hetzner Ryzen 3700x
Or maybe dual Xeon 2670 or similar would give alot more performance?
Thanks ;)


  • What's the Postgresql version? I supposed you have done all usual optimization?

  • vimalwarevimalware Member
    edited November 2019
    # su postgres
    cd /var/lib/postgresql/
    chmod +x

    Fix all the medium to high recommendations.


    Thanked by 2nullnothere ehab
  • Anyway just a quick note that if you really want to upgrade, you want more cores. An EPYC might be the best bet if you really face CPU issues after optimization.

  • dodheimsgard said: Looks like CPU is startig to be bottleneck.

    I would hazard (without really knowing too much about your schema/use cases), that there's probably plenty of tuning opportunities that you can take advantage of before going with any hardware upgrade. It is very rarely that I've seen a DB genuinely be CPU bound and more often than not it's poorly written queries, non-existing or badly designed indexes, may be evening no regular maintenance jobs and things like that that bring a DB down to its knees.

    My $0.02

    Thanked by 2vimalware pinc
  • Run the PostgreSQL tuner, if you still have issues go for the AX41-NVMe, and get some ECC please (running DBs on i7s, not the smartest idea).

Sign In or Register to comment.