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 CADBz386QsbgwYyQWvbda_DNVcOtatV-djp=mrc8O-gmUHg4L1A@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 5:51 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
Usually what is seen here is the opposite, that tables are restored and
ANALYZE is not run and performance on the subsequent queries is poor due
to lack of current statistics.

What is the restore process?

For these specific legacy db tables, they are isolated in a separate schema.  We then use pg_restore to restore the entire schema.  Essentially just:

pg_restore -n wss --no-owner

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