postgresql

Documentation

Index

• func GetDefaultPostgresMaxConnections(instanceClass string) (int, error)
• func GetPostgresMaxConnections(rawMaxConnections string, instanceClass *string) (int, error)

Functions

func GetDefaultPostgresMaxConnections

func GetDefaultPostgresMaxConnections(instanceClass string) (int, error)

Aurora PostgreSQL: "LEAST({DBInstanceClassMemory/9531392},5000)" Default is set to this value for all instance classes. Note that the DBInstance Class Memory, which is 5000, is, DBInstanceClassMemory = 5000 * 9531392(Byte) = 47656960000(Byte)

= 47.65696(GB)

In other words, for instances with a memory size larger than 47.65696 GB, max_connection is 5000. ref: https://aws.amazon.com/rds/instance-types/

func GetPostgresMaxConnections

func GetPostgresMaxConnections(rawMaxConnections string, instanceClass *string) (int, error)

Parse rawMaxConnections and calculate with instance class.

Example of raw values: Aurora PostgreSQL: "LEAST({DBInstanceClassMemory/9531392},5000)" Aurora MySQL: "GREATEST({log(DBInstanceClassMemory/805306368)*45},{log(DBInstanceClassMemory/8187281408)*1000})" RDS Postgres: Same with Aurora PostgreSQL RDS MySQL: {DBInstanceClassMemory/12582880}