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
[email protected]
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to
this email
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general