On 2019-Oct-23, kato-...@fujitsu.com wrote: > Hello > > 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). > > I did the same thing in another server which has 200GB memory, but creating > foreign key did not end in 24 hours.
Thanks for reporting. It sounds like there must be a memory leak here. I am fairly pressed for time at present so I won't be able to investigate this until, at least, mid November. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services