On 05/01/2013 10:17 AM, Larry Rosenman wrote:
I have an app that we have a number of tables that all have FK relationships with the account table.
OK so far.
Referenced by: * Redacted one-billion foreign keys
Wow. I really hope every single one of those tables has an index on the listed column, and it's the same datatype (bigint). Otherwise, this is going to take a long, long time.
-- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-676-8870 sthomas@xxxxxxxxxxxxxxxx ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general