From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | catalin(at)plationline(dot)eu, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: random huge delay when recreate a VIEW or FUNCTION |
Date: | 2016-06-15 14:01:36 |
Message-ID: | CANu8Fiyz3_qxt8-eDAJXCBOLADzhkU-aBmjRGjyFcrGUyjACQg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Jun 15, 2016 at 12:36 AM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
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
>>
>>
>>
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
In addition to Adrian's questions,
What is the O/S you are using?
How much total memory is in the system?
What are the values for shared_buffers, work_mem & maintenance_work_mem?
What is the actual SQL for the view and/or function change you are doing?
All of these can have a factor in your delay.
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2016-06-15 14:03:35 | Re: Changelog version from 8.1.2 to 9.3.6 |
Previous Message | Alexander Farber | 2016-06-15 13:58:28 | Re: Moving from PHP to Java: A result was returned when none was expected. |