Re: Partitioning tables

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx

27 Melcher Street

Boston, MA  02210

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux