From: Jernigan, Kevin <kmj@amazon.com>
To: Campbell, Lance <lance@illinois.edu>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Partitioning tables
Date: Fri, 6 Jul 2018 21:39:50 +0000
Message-ID: <C534AEEF-8581-45F6-9B41-5B774995740A@amazon.com> (raw)
In-Reply-To: <56F9CFE5-3253-4258-92C9-E5A4DC1EC147@illinois.edu>
References: <56F9CFE5-3253-4258-92C9-E5A4DC1EC147@illinois.edu>
Assume you are reading and writing regularly to a given table.
1) When using Amazon RDS PostgreSQL 10, is there any reason to use table partitioning?
2) If so what might be a few simple examples of when to use it?
3) Also, if there is a reason then how large should a table be before it should be partitioned? I am just wanting some general idea or scope.
It is always a good idea to occasionally revaluate if going down a particular path still makes sense.
Thanks,
Lance
RDS for PostgreSQL 10, and prior versions of RDS for PostgreSQL, run on EBS storage. One key benefit of table partitioning is partition elimination for queries that would otherwise scan the entire table, and this benefit applies to RDS for PostgreSQL. More generally, the benefits described in the postgresql.org doc here - https://www.postgresql.org/docs/10/static/ddl-partitioning.html - are applicable for RDS for PostgreSQL, except for the last one listed – Seldom-used data can be migrated to cheaper and slower storage media.
Kevin Jernigan
Senior Product Manager
Amazon Aurora PostgreSQL
1-415-710-8828 (m)
kmj@amazon.com<mailto:kmj@amazon.com>
27 Melcher Street
Boston, MA 02210
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kmj@amazon.com, lance@illinois.edu
Subject: Re: Partitioning tables
In-Reply-To: <C534AEEF-8581-45F6-9B41-5B774995740A@amazon.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox