Re: [ADMIN] any tricks to get foreign key constraint builds faster

2011-06-06 Thread Kevin Grittner
Mike Broers wrote: > Should this be posted in performance instead? The readers of that list, while there is some overlap, would overall be a better group for getting your answer. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:

Re: [ADMIN] any tricks to get foreign key constraint builds faster

2011-06-06 Thread Mike Broers
Should this be posted in performance instead? On Fri, Jun 3, 2011 at 9:46 AM, Mike Broers wrote: > 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 const

[ADMIN] any tricks to get foreign key constraint builds faster

2011-06-03 Thread Mike Broers
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 a