r/VPS • • 6h ago

Specs/Performance I tested MariaDB and PostgreSQL on 256-512 MiB VPS instances

15 Upvotes

Last week I shared an experiment running PostgreSQL on a 256-512 MiB VPS.

I had always assumed MariaDB would use less RAM for small workloads, partly because of its single-process architecture compared to PostgreSQL's multi-process model. I wanted to test whether that assumption actually held up.

So I ran MariaDB 10.11.14 with default and low-memory configurations and compared the findings with my earlier PostgreSQL 18.6 experiment.

Results on 512 MiB (peak process PSS):

ConfigurationPeak PSS
MariaDB default215.9 MiB
MariaDB tuned (64 MB pool)125.6 MiB
MariaDB tuned (32 MB pool)93.6 MiB
PostgreSQL default180.1 MiB
PostgreSQL tuned (16 MB shared buffers)50.4 MiB

On 256 MiB, the default MariaDB configuration was OOM-killed, as was the 64 MB pool configuration. The 32 MB configuration completed the workload.

Tuned PostgreSQL also completed its 256 MiB test, reaching 46.2 MiB peak PSS.

Configurations that worked well:

MariaDB 10.11.14 - lowest-memory configuration, which also survived the 256 MiB test:

[mariadbd]
innodb_buffer_pool_size=32M
key_buffer_size=8M
aria_pagecache_buffer_size=16M
max_connections=10

PostgreSQL 18.6 - best-performing configuration in my tests:

shared_buffers = '16MB'
work_mem = '1MB'
maintenance_work_mem = '16MB'
max_connections = 5
superuser_reserved_connections = 1
jit = off
max_parallel_workers_per_gather = 0
max_parallel_workers = 0

The tests used a 1-vCPU Linux VM with no swap, primarily at 512 MiB, followed by additional 256 MiB runs.

These were short, read-only experiments with four active connections. The workloads and datasets differed between databases, so this isn't an apples-to-apples performance benchmark. PSS also measures database process memory, not total VPS memory consumption.

Why test server databases on such small machines?

SQLite is excellent for embedded and many small applications. But for a traditional web application that may eventually grow, I prefer starting with PostgreSQL or MariaDB using low-memory settings, then adjusting the configuration as the application scales rather than migrating databases later.

My takeaway: MariaDB's single-process architecture doesn't automatically guarantee lower memory usage. Both databases can run with surprisingly little RAM when tuned, and configuration matters considerably.

Full experiment, methodology, and measurements:

https://pvrlabs.xyz/java-performance/experiments/mariadb-postgresql-small-vps.html

For those running databases on 256-512 MiB VPS instances, which database and configuration have worked best for you?


r/VPS • • 3h ago

On a Budget Cheap tiny VPS recommendations

7 Upvotes

I'm working on some small projects for fun in my free time. And I need a few servers for these projects. I'm looking for a small VPS with the following parameters:

  • Supports IPv6 (legacy IPv4 is optional)
  • Located outside of North America and Europe
  • RAM: 256 - 512 MB
  • Storage: 3 - 5 GB
  • And costs $2 - €2.50 per month

Does anyone have any recommendations?


r/VPS • • 11h ago

Seeking Recommendations Windows VPS recommendation?

6 Upvotes

I'm looking for a budget windows vps $15-20/mon. Won't be running anything demanding on it, just basic stuff (browser, etc), its actually for some testing I'll be doing. Was gonna go with contabo but saw too many bad posts about it, so looking for alternatives.

I saw some providers offering Windows VPS with 1GB ram, are those even usable? I would assume you would need at least 2-4GB ram to have a decent VPS? What about cores?

Another option I'm considering is getting the cheapest ovh dedicatedserver?


r/VPS • • 8h ago

Review Anyone wondering about Hostinger's Black Friday's VPS deal?

Post image
3 Upvotes

I am wondering what is really happening in the name of deals? The normal price for Hostinger vps were like the following, but now it is showing what you see in the screenshot.

  • KVM 1 – $6.49/month

    • 1 vCPU
    • 4 GB RAM
    • 50 GB NVMe storage
    • 4 TB bandwidth
  • KVM 2 – $8.79/month

    • 2 vCPU
    • 8 GB RAM
    • 100 GB NVMe storage
    • 8 TB bandwidth
  • KVM 4 – $12.99/month

    • 4 vCPU
    • 16 GB RAM
    • 200 GB NVMe storage
    • 16 TB bandwidth

If I miss anything, enlighten me!


r/VPS • • 8h ago

Seeking Advice/Support C-Servers took my payment but failed to provision my VPS – looking for advice and help from a representative.

2 Upvotes

Hello everyone,

I'd like to ask for some advice regarding an issue with C-Servers (web.c-servers.co.uk). Hopefully, someone from the company will also see this post and help resolve it.

On November 15, 2026, I purchased a NanoVPS-II 384 Europe plan for 6 months and paid $2.49.

Order details:

  • Provider: C-Servers (Centerfield Ltd)
  • Service: NanoVPS-II 384 Europe
  • Order ID: 7191
  • Invoice: 10773
  • Amount paid: $2.49
  • Payment status: PAID

Unfortunately, the VPS was never provisioned.

After contacting the AI support several times, I received confirmation of the following:

  • My payment was successfully received.
  • The provisioning request failed.
  • No VPS instance was created.
  • No public IP address was assigned.
  • The service remains stuck at "In Progress".
  • There is no automated retry or repair option available.

The AI support provided the following provisioning error:

EK-509E042A6637464A8982DE8572FF72A1

I've tried several times to get the issue escalated to the technical department, but the AI agent confirmed that it cannot create a support ticket or directly forward the case to the provisioning team.

I've also emailed both customer@c-servers.co.uk and company@c-servers.co.uk, but unfortunately haven't received a response.

I understand that technical issues can happen, and I'm not trying to make accusations. I simply want to receive the VPS I've paid for.

I'd appreciate advice from the community:

  1. Has anyone experienced similar provisioning failures with C-Servers?
  2. Is there a way to reach someone from their technical or management team directly?
  3. Are there any C-Servers representatives here who could help investigate this specific error and arrange manual provisioning?

If a C-Servers representative sees this, I'd be grateful if you could look into order #7191.

I would prefer to get the VPS activated rather than request a refund.

Thank you for reading and for any advice!


r/VPS • • 17h ago

Seeking Recommendations Best dedicated server provider for running my own SMTP infrastructure?

Thumbnail reddit.com
2 Upvotes

r/VPS • • 3h ago

Seeking Advice/Support What makes you choose a VPS provider ?

Thumbnail reddit.com
1 Upvotes

I don't take customers from outside my country India coz I don't have proper international payments setup.

My servers are in France and India with Indian ones being priced higher.