Partitioning tables - Mailing list pgsql-admin

From Campbell, Lance
Subject Partitioning tables
Date
Msg-id 56F9CFE5-3253-4258-92C9-E5A4DC1EC147@illinois.edu
Whole thread Raw
Responses Re: Partitioning tables  ("Jernigan, Kevin" <kmj@amazon.com>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: mohammed shahid
Date:
Subject: Re: "postgres" is needed by initdb but was not found
Next
From: Tom Lane
Date:
Subject: Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls,