Partition tables in AWS RDS environment

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Partition tables in AWS RDS environment
Date: 2017-04-10 13:50:43
Message-ID: B75CD08C73BD3543B97E4EF3964B7D7047B47CF7@CITESMBX1.ad.uillinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

PostgreSQL 9.6.2

My group is planning on moving our PostgreSQL install to AWS. We plan to use their RDS option for running PostgreSQL. When we make this move is there any reason to use Partitioned Tables on really large tables? Will we get any performance gain?

I know we would get a performance gain on really large tables if we partitioned them and put their partitions in different table spaces that use different disks. However since we are looking at using the more generalized hands off automated AWS RDS PostgreSQL option I don't see us using table spaces and different disks. So would there be any gain in partitioning tables in the more automated AWS RDS PostgreSQL path?

Thanks,

Lance Campbell
University of Illinois

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Campbell, Lance 2017-04-10 13:57:16 Re: Partition tables in AWS RDS environment
Previous Message Jehan-Guillaume de Rorthais 2017-04-10 08:48:44 Re: How do you manage cluster replication and failover ?