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

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Too slow to create new schema and their tables, functions, triggers.
Date: 2019-07-26 08:46:18
Message-ID: bfaad3e2-a09f-8b69-d744-c66ed4edd7a9@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message PegoraroF10 2019-07-26 11:05:58 Re: Too slow to create new schema and their tables, functions, triggers.
Previous Message Cyril Champier 2019-07-26 08:14:24 Re: Default ordering option