Re: Creating foreign key on partitioned table is too slow

From: Andres Freund <andres(at)anarazel(dot)de>
To: "kato-sho(at)fujitsu(dot)com" <kato-sho(at)fujitsu(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Creating foreign key on partitioned table is too slow
Date: 2019-10-24 23:28:38
Message-ID: 20191024232838.lbqyygqknvefxsas@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2019-10-23 05:59:01 +0000, kato-sho(at)fujitsu(dot)com wrote:
> To benchmark with tpcb model, I tried to create a foreign key in the partitioned history table, but backend process killed by OOM.
> the number of partitions is 8192. I tried in master(commit: ad4b7aeb84).

Obviously this should be improved. But I think it's also worthwhile to
note that using 8k partitions is very unlikely to be a good choice for
anything. The metadata, partition pruning, etc overhead is just going to
be very substantial.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Maciek Sakrejda 2019-10-24 23:31:39 Re: EXPLAIN BUFFERS and I/O timing accounting questions
Previous Message Tomas Vondra 2019-10-24 23:07:56 Re: Creating foreign key on partitioned table is too slow