Re: ***SPAM*** Re: random huge delay when recreate a VIEW or FUNCTION

hei Adrian,

thx for your reply,

this is an example:

"CREATE OR REPLACE VIEW feedback.get_answers_set AS
  SELECT f.awb || '/' || r.dulapid as "awb",
     q.qid,
     q.question,
     a.aid,
     a.answer,
     q.questionareid,
     f.stamp_created
     , c.first_name
     , l.referinta_expeditor
FROM feedback.answers a
      JOIN feedback.questions q ON a.qid = q.qid
      JOIN feedback.feedback f ON f.qid = q.qid AND f.aid = a.aid
      join public.livrari_details ld on ld.awb=f.awb
      join public.livrari l on l.livrareid = ld.livrareid
      join public.customers c on l.shipto_custkey = c.custkey
      join dulap.rezervare r on r.rezid = l.rezervareid;

ALTER TABLE feedback.get_answers_set
   OWNER TO postgres;"


I use PGADMIN 1.22.1

my server is remote and is replicated Master-Slave.


my team report this random delay all the time when we recreate VIEWS and
FUNCTIONS.



Best regards,
Catalin Maftei
www.plationline.eu
www.livrarionline.ro
www.c-solution.biz

Skype: catalinmaftei
Mobile: +40723 338 598

On 6/15/2016 7:36 AM, Adrian Klaver wrote:
> On 06/14/2016 02:59 PM, Catalin Maftei wrote:
>> when I recreate a VIEW or FUNCTION with a small change I get:
>
> What are the actual statements you are running?
>
> What program are you running them from?
>
> Is the server you are running the command against local or remote?
>
>
>
>>
>> Query returned successfully with no result in 03:58 minutes.
>>
>>
>> we have pg 9.4
>>
>> --
>> Best regards,
>> Catalin Maftei
>> www.plationline.eu
>> www.livrarionline.ro
>> www.c-solution.biz
>>
>> Skype: catalinmaftei
>> Mobile: +40723 338 598
>>
>>
>>
>>
>
>