On Wed, Jun 15, 2016 at 12:36 AM, Adrian Klaver <adrian.kla...@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.kla...@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 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.