Re: pg_dump restore time and Foreign Keys

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump restore time and Foreign Keys
Дата
Msg-id 19956.1213025599@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump restore time and Foreign Keys  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: pg_dump restore time and Foreign Keys  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> 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.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Potential deadlock with auto-analyze
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pg_dump restore time and Foreign Keys