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

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: catalin(at)plationline(dot)eu
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ***SPAM*** Re: random huge delay when recreate a VIEW or FUNCTION
Date: 2016-06-16 23:55:54
Message-ID: CANu8FiyWKaBGVoM0LbBX+3tWQnBZkZ6gYaJ3hP3EdQ-TToTQnQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jun 15, 2016 at 12:49 AM, Catalin Maftei <catalin(at)plationline(dot)eu>
wrote:

> 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
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://stream.boxwatch.ru/mailpref/pgsql-general
>
>

*You have not provided information as to the O/S of the PostgreSQL server
or your PgAdmin remote system (I suspect Windows), but regardless, you are
just asking for trouble by doing development over a remote connection.You
should verify there is no delay by connecting directly to the PostgreSQL
server and testing the CREATE OR REPLACE there. I suspect you will have
none or very minimal delay.Hopefully PostgreSQL is on a Linux O/S and you
can use Putty for Windows
http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html
<http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html> to
connect directly and develop.*--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Erdmann, Markus @ Bellevue 2016-06-17 00:40:26 Regression in query optimizer when upgrading from 9.4.5 to 9.5.2?
Previous Message John R Pierce 2016-06-16 21:32:33 Re: maximum "target list" (maximum columns)