Partitioning tables

Поиск
Список
Период
Сортировка
От Campbell, Lance
Тема Partitioning tables
Дата
Msg-id 56F9CFE5-3253-4258-92C9-E5A4DC1EC147@illinois.edu
обсуждение исходный текст
Ответы Re: Partitioning tables
Список 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 по дате отправления:

Предыдущее
От: mohammed shahid
Дата:
Сообщение: Re: "postgres" is needed by initdb but was not found
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore error Command was: CREATE OPERATOR ~> ( PROCEDURE = plv8x.json_eval_ls,