Re: random huge delay when recreate a VIEW or FUNCTION - Mailing list pgsql-general
On Wed, Jun 15, 2016 at 12:36 AM, Adrian Klaver <adrian.klaver@aklaver.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.klaver@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.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 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.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
pgsql-general by date: