Postgres Pro
Downloads
Home   >   mailing lists

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

From Vikas Sharma
Subject Partitioning large table (140GB)
Date
Msg-id CAN6gwKyuosNZKsZ=JnpJLimvtYx1RGtnSZ4r328s_J+GNuLLKg@mail.gmail.com
Whole thread Raw
Responses Re: Partitioning large table (140GB)  ("Ravi Krishna" <srkrishna@myself.com>)
List pgsql-general
Tree view
Hi There,

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?

Thanks & Regards
Vikas

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: How should I specify work_mem/max_worker_processes if I want todo big queries now and then?
Next
From: "Ravi Krishna"
Date:
Subject: Re: Partitioning large table (140GB)