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 CADBz38788sE8G54daHmfVYkaMhYTEdFyd--BtdF=2BOJGuj8Gw@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
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 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