On Mon, 2008-06-09 at 11:33 -0400, Tom Lane wrote: > Simon Riggs <[EMAIL PROTECTED]> writes: > > On Mon, 2008-06-09 at 10:57 -0400, Tom Lane wrote: > >> Ah, finally a useful comment. I think it might be possible to do an > >> "add FK concurrently" type of command that would take exclusive lock > > > That's good, but it doesn't solve the original user complaint about > > needing to re-run many, many large queries to which we already know the > > answer. > > No, we are running a large query to which the user *thinks* he knows the > answer. There are any number of reasons why he might be wrong.
Of course. I should have said "to which we already know the answer" to indicate I'm passing on others' criticisms of us. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
