How Many Partitions are Good Performing

From: "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How Many Partitions are Good Performing
Date: 2018-01-08 23:20:13
Message-ID: b6d4d767cdbb4c8aadf51a502277f125@USFKL11XG20CN01.mercer.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can somebody tell us how many partitions are good number without impacting the performance. We are hearing around a thousand, is that a limit. Do we have plan to increase the number of partitions for a table. We would appreciate if somebody can help us with this?

Regards,
Virendra

________________________________

This message is intended only for the use of the addressee and may contain
information that is PRIVILEGED AND CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified that any
dissemination of this communication is strictly prohibited. If you have
received this communication in error, please erase all copies of the message
and its attachments and notify the sender immediately. Thank you.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rakesh Kumar 2018-01-08 23:54:18 Re: How Many Partitions are Good Performing
Previous Message Márcio A. Sepp 2018-01-08 22:44:40 RES: Supartitions in PGSQL 10