Posted On: Jan 21, 2021
PostgreSQL partitioning allows you to split one large table into smaller physical pieces for better performance. For example, you can partition time-series data by date and retrieve data about a period of interest faster. pg_partman simplifies management of partitioned tables in PostgreSQL by automating creation and maintenance of your table partitions. Amazon RDS supports pg_partman in PostgreSQL versions 12.5 and higher.
Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Learn more about upgrading your database instances from the Amazon RDS User Guide. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability. Create or update a fully managed Amazon RDS database in the Amazon RDS Management Console.