Re: postgres 9.6: insert into select finishes only in pgadmin not psql

Поиск
Список
Период
Сортировка
От Corey Taylor
Тема Re: postgres 9.6: insert into select finishes only in pgadmin not psql
Дата
Msg-id CADBz38788sE8G54daHmfVYkaMhYTEdFyd--BtdF=2BOJGuj8Gw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgres 9.6: insert into select finishes only in pgadmin notpsql  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: postgres 9.6: insert into select finishes only in pgadmin notpsql
Список pgsql-general
Дерево обсуждения
On Mon, Sep 23, 2019 at 4:31 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
Hmm, are there triggers on wss_entries that are UPDATEing/DELETEing
entries elsewhere?

No, that table is pretty much stand-alone.  What we're seeing here is most likely caused by the initial copy of the legacy db tables.

This happens when creating the local test db which I do right before the tests.  I can avoid the issue if I monitor top and wait for the analyze to complete on all the related tables. 

corey

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: postgres 9.6: insert into select finishes only in pgadmin notpsql
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: postgres 9.6: insert into select finishes only in pgadmin notpsql