DEV Community

Pacharapol Withayasakpunt
Pacharapol Withayasakpunt

Posted on

How much does Postgres cost?

Of course, I don't mean about Heroku free tier.

What if I go beyond 10k rows? What if sleeping time and dyno size matters? What is the starting price, and how does it escalate? What about related services, like Hasura or Scalegrid?

IMO, with JOIN and INDEX, I can easily exceed 10k rows.

What I want beyond relational data would be full-text-search and automatic backup.

Top comments (2)

Collapse
 
mayowa profile image
mayowa

I know your question is heroku specific, but have you considered using a VPS?
A $5 VPS from either DigitalOcean or Linode would make managing your costs a lot more predictable not to talk of cheaper.

AFAICT nothing prevents you from using Heroku for your code and a VPS for your database

Installing postgres on an Ubuntu server is a s simple as

sudo apt install postgresql
Enter fullscreen mode Exit fullscreen mode

Creating the database

sudo -u postgres psql -c "create database myappdb with encoding utf8"
Enter fullscreen mode Exit fullscreen mode

And so on.

My appologies if I've somehow missed the obvious, but if your project requirements/limitations do not bind you to using Heroku for your entire stack, perhaps you might want to consider this alternative

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt

I do consider that, but I am not sure if I am ready for sysadmin job.

Other than the database itself, I will need,

  • Monitoring
  • Backup, with crontab

I will consider it later, after I exceed the limit.