Re: adding a column takes FOREVER!

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: adding a column takes FOREVER!
Date: 2011-10-22 13:03:40
Message-ID: j7uevb$d82$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote on 22.10.2011 05:24:
> I'm thinking there is something you haven't told us about that creates a
> great deal of overhead for updates on this table. Lots and lots o'
> indexes? Lots and lots o' foreign key references?

Why would an add column need to check foreign key references?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message miesi 2011-10-22 13:48:47 Understanding the output of make check
Previous Message Alexander Bruy 2011-10-22 12:58:14 Building pgRouting against PostgreSQL 9.1.1 with MinGW