On 2013-05-01 10:23, Shaun Thomas wrote:
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.
Yes, all of them have at least one index that has account_id as the
first column (we use that to
separate tenants in a multi-tenant app).
I still wonder if there is a way to see where it is :(
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-642-9640 (c) E-Mail: ler@xxxxxxxxxx
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
