Re: Too slow to create new schema and their tables, functions,triggers. - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Too slow to create new schema and their tables, functions,triggers.
Date
Msg-id bfaad3e2-a09f-8b69-d744-c66ed4edd7a9@gmx.net
Whole thread Raw
In response to Re: Too slow to create new schema and their tables, functions,triggers.  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: Too slow to create new schema and their tables, functions,triggers.  (PegoraroF10 <marcos@f10.com.br>)
List pgsql-general
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? 






pgsql-general by date:

Previous
From: Cyril Champier
Date:
Subject: Re: Default ordering option
Next
From: PegoraroF10
Date:
Subject: Re: Too slow to create new schema and their tables, functions,triggers.