Book Image

Learning Heroku Postgres

By : Patrick Rafael de Oliveira Espake
Book Image

Learning Heroku Postgres

By: Patrick Rafael de Oliveira Espake

Overview of this book

Table of Contents (17 chapters)
Learning Heroku Postgres
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Keyword List
Index

Choosing the right Heroku Postgres plan


Heroku offers three lines of plans with some differences in characteristics, these changes were made to suit small applications to applications that have a large volume of data or need transactional control.

Choosing the best plan will depend on the needs of your application. At any time, you can upgrade your database plan and optimize your application with a very short period of downtime. You will see more information about this in Chapter 6, Rollback, Followers, and Forks.

The main variations between the plans are expected downtime supported:

  • Hobby tier tolerates 4 hours of downtime and is used for small and simple applications.

  • Standard tier tolerates 1 hour of downtime and is used for production applications.

  • Premium tier tolerates 15 minutes of downtime and is used for production applications where uptime is important.

The following table shows the main differences between the plans offered by Heroku and their respective prices:

Plan

Connection Limit

Row Limit

RAM

Storage

Price

Hobby Dev

20

10,000

0 Bytes

No

Free

Hobby Basic

20

10,000,000

0 Bytes

No

$9/mo

Standard 0

120

Unlimited

1 GB

64 GB

$50/mo

Premium 0

120

Unlimited

1 GB

64 GB

$200/mo

Standard 2

400

Unlimited

3.5 GB

256 GB

$200/mo

Premium 2

400

Unlimited

3.5 GB

256 GB

$350/mo

Standard 4

500

Unlimited

15 GB

512 GB

$750/mo

Premium 4

500

Unlimited

15 GB

512 GB

$1200/mo

Standard 5

500

Unlimited

30 GB

1 TB

$1400/mo

Standard 6

500

Unlimited

60 GB

1 TB

$2000/mo

Premium 5

500

Unlimited

30 GB

1 TB

$2500/mo

Premium 6

500

Unlimited

60 GB

1 TB

$3500/mo

Standard 7

500

Unlimited

120 GB

1 TB

$3500/mo

Premium 7

500

Unlimited

120 GB

1 TB

$6000/mo

Shared features

All the plans share the following features:

  • Data clips to share data and queries with others people securely

  • SSL protection to access psql/libpq

  • Postgres extensions

  • Web UI interface to manage the database

  • Unmodified versions of Postgres

  • Database service fully managed for automatic health checks

  • Write-ahead log (WAL) that ensures minimal data loss in case of catastrophic failure, storing every minute