Re: Creating foreign key on partitioned table is too slow - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Creating foreign key on partitioned table is too slow
Date
Msg-id 20191024232838.lbqyygqknvefxsas@alap3.anarazel.de
Whole thread Raw
In response to Creating foreign key on partitioned table is too slow  ("kato-sho@fujitsu.com" <kato-sho@fujitsu.com>)
Responses Re: Creating foreign key on partitioned table is too slow  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Hi,

On 2019-10-23 05:59:01 +0000, kato-sho@fujitsu.com wrote:
> To benchmark with tpcb model, I tried to create a foreign key in the partitioned history table, but backend process
killedby 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



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Creating foreign key on partitioned table is too slow
Next
From: Michael Paquier
Date:
Subject: Re: v12.0: reindex CONCURRENTLY: lock ShareUpdateExclusiveLock onobject 14185/39327/0 is already held