Re: Partitioning large table (140GB) - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Partitioning large table (140GB)
Date
Msg-id trinity-c080158b-3124-4989-8c4f-65310bd05eb7-1574246959204@3c-app-mailcom-lxa11
Whole thread Raw
In response to Partitioning large table (140GB)  (Vikas Sharma <shavikas@gmail.com>)
Responses Re: Partitioning large table (140GB)  (Andrei Zhidenkov <andrei.zhidenkov@n26.com>)
List 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 by date:

Previous
From: Vikas Sharma
Date:
Subject: Partitioning large table (140GB)
Next
From: Andrei Zhidenkov
Date:
Subject: Re: Partitioning large table (140GB)