Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres 9.6: insert into select finishes only in pgadmin not psql - Mailing list pgsql-general

From Corey Taylor
Subject Re: postgres 9.6: insert into select finishes only in pgadmin not psql
Date
Msg-id CADBz3868gUM2TL25svb6x8UWWEEh21msf1zdFqNiSukzZEry_w@mail.gmail.com
Whole thread Raw
In response to Re: postgres 9.6: insert into select finishes only in pgadmin notpsql  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: postgres 9.6: insert into select finishes only in pgadmin notpsql
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: postgres 9.6: insert into select finishes only in pgadmin notpsql
Next
From: Adrian Klaver
Date:
Subject: Re: postgres 9.6: insert into select finishes only in pgadmin notpsql