Search Postgresql Archives

Re: postgres 9.6: insert into select finishes only in pgadmin not psql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Mon, Sep 23, 2019 at 4:31 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux