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 CADBz3868gUM2TL25svb6x8UWWEEh21msf1zdFqNiSukzZEry_w@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 7:23 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
"Once restored, it is wise to run ANALYZE on each restored table so the
optimizer has useful statistics; see Section 24.1.3 and Section 24.1.6
for more information."

So is there some other step in the process that occurs after the restore
and before you run your function?

There are several other restore called and a delete query that clears out an unrelated table.

However, I think this solves the issue for us and the mystery. The ANALYZE was missing which reduces an unending query down to a minute.  The ANALZYE runs very quickly on its own so we're simply going to fix the issue by following documented advice.

I guess the length of the query when before/during the ANALZYE felt like something more was wrong.

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