Hi, On 2019-10-23 05:59:01 +0000, kato-...@fujitsu.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