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

Production-tier technical characterization


The Standard, Premium, and Enterprise plans are offered for production applications that require certain operating characteristics based on multitenancy architectures, CPU, RAM, and IO. These characteristics can be more easily understood with the help of the following table:

Plan

vCPU

RAM

Disk Size

Connection Limit

PIOPs

Multitenant

Standard 0

Premium 0

2

1 GB

64 GB

120

200

Yes

Standard 2

Premium 2

2

3.5 GB

256 GB

400

200

Yes

Standard 4

Premium 4

2

15 GB

512 GB

500

1000

No

Standard 5

Premium 5

4

30 GB

1 TB

500

2000

No

Standard 6

Premium 6

8

60 GB

1 TB

500

3000

No

Standard 7

Premium 7

Enterprise 7

16

120 GB

1 TB

500

4000

No

Enterprise 8

32

240 GB

1 TB

500

4000

No

All plans run a 64-bit architecture, which ensures the best performance for the internal operations of Postgres. Heroku Postgres runs on a virtual infrastructure provided by Amazon AWS EC2.

The vCPU is the number of virtual processors in the instance and RAM is the amount of memory used to data cache. The PIOPs are a measure of how many IO disk operations can be performed per second.

For applications that require a lot of writes, IO can be a critical point. The data sets should fit in RAM, which ensures high performance with lower values of IOPs (Input/Output operations per second).

Finally, multitenancy refers to the principle of software architecture where a software instance is a server serving multiple client organizations (tenants).