Re: Partitioning large table (140GB)

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема Re: Partitioning large table (140GB)
Дата
Msg-id trinity-c080158b-3124-4989-8c4f-65310bd05eb7-1574246959204@3c-app-mailcom-lxa11
обсуждение исходный текст
Ответ на Partitioning large table (140GB)  (Vikas Sharma <shavikas@gmail.com>)
Ответы Re: Partitioning large table (140GB)
Список pgsql-general
>In our production, we use postgres 9.5 with streaming replication
>using repmgr, there is a large table of 140GB size which receives
>lots of inserts,
>Is it possible to partition this table in this version of postgres?
>and if so, please, can someone let me know the best way to accomplish
>this and the best practices around it?

In this version only inheritance is possible.  From my experience avoid using
triggers for insert and let the application (if possible) directly write to the
right table.
 
 



В списке pgsql-general по дате отправления:

Предыдущее
От: Vikas Sharma
Дата:
Сообщение: Partitioning large table (140GB)
Следующее
От: Andrei Zhidenkov
Дата:
Сообщение: Re: Partitioning large table (140GB)