Re: [table partitioning] How many partitions are possibel?

Hi,

Am 2017-12-26 hackte Michael Paquier in die Tasten:
------------------------------------------------------------------------
> On Tue, Dec 26, 2017 at 11:04:55AM +0100, Michelle Konzack wrote:
>> I like to make the partitions smaller, but the documentation say, you
>> should not dare to make several 1000 partitions..
>
> Even more than a hundred may be already risky in my opinion here. The
> issue with a large number of partitioning using the pre-9.6 grammar
> comes from the planning time which sky-rockets because the optimizer
> uses a O(N^2) algorithm to consider all the partitions. The v10 grammar
> does not take care of this planning problem as far as I recall, but v11
> gets that better for partition-wise joins if my memory does not fail me.
> --
> Michael

I think on migrating to v10, but I have to backport the PostgreSQL.

Currently I am thinking about hot to backup 28 TByte of data...
Have to dump and compress table by table and thios take endless time,
especially, if I am in Estonia and the database is in Germany.

Is there already a rease date for v11?

Thanks in avance

--
Michelle Konzack
00372-54541400