Mike Broers <mbroers@xxxxxxxxx> writes: > I am in the process of implementing cascade on delete constraints > retroactively on rather large tables so I can cleanly remove deprecated > data. The problem is recreating some foreign key constraints on tables of > 55 million rows+ was taking much longer than the maintenance window I had, > and now I am looking for tricks to speed up the process, hopefully there is > something obvious i am overlooking. maintenance_work_mem? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
