Note: We will not use PostgreSQL going forward and will focus on MariaDB for SQL. However, this documentation may be useful for general PostgreSQL tips.
Amazon RDS PostgreSQL v10 Parameter Groups
| Name | Description | Allowed Values | Suggested Value |
|---|---|---|---|
| pg_stat_statements.track | Selects which statements are tracked by pg_stat_statements. | NONE, TOP, ALL | ALL |
| random_page_cost | Sets the planners estimate of the cost of a nonsequentially fetched disk page. | 0-1.79769e+308 | 1 |
| shared_preload_libraries | Lists shared libraries to preload into server. | auto_explain, orafce, pgaudit, pglogical, pg_hint_plan, pg_similarity, pg_stat_statements, pg_transport, plprofiler | pg_stat_statements |
| track_activity_query_size | Sets the size reserved for pg_stat_activity.current_query, in bytes. | 100-102400 | 2048 |