Search Postgresql Archives

Re: Too slow to create new schema and their tables, functions, triggers.

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

 



PegoraroF10 schrieb am 26.07.2019 um 00:16:
> statement: create or replace function valoresdfe...     0 mins 1.135 secs
> statement: create or replace function dadosorigem...    0 mins 0.055 secs
> statement: CREATE OR REPLACE FUNCTION SONU...           0 mins 0.013 secs
> statement: create or replace function contatoscampa...	2 mins 13.492 secs
> statement: create or replace function FORMATARTELEF...  0 mins 0.013 secs
> statement: create or replace function ChecaVar          0 mins 0.012 secs
> statement: CREATE or replace FUNCTION criatrigge...     1 mins 16.42 secs
> 

Is it possible those functions (were creating was slow) were still in use 
by another session and the create script had to wait for an exclusive lock to replace the function? 








[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