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 CADBz386QsbgwYyQWvbda_DNVcOtatV-djp=mrc8O-gmUHg4L1A@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 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 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