Re: Partitioning large table (140GB)

From: "Ravi Krishna" <srkrishna(at)myself(dot)com>
To: "Vikas Sharma" <shavikas(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Partitioning large table (140GB)
Date: 2019-11-20 10:49:19
Message-ID: trinity-c080158b-3124-4989-8c4f-65310bd05eb7-1574246959204@3c-app-mailcom-lxa11
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
 
 

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrei Zhidenkov 2019-11-20 10:51:09 Re: Partitioning large table (140GB)
Previous Message Vikas Sharma 2019-11-20 08:41:13 Partitioning large table (140GB)