Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Jun 16, 2016 at 6:55 PM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:
 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 to connect directly
> and develop.

I responded on his other thread.  Locks need to be ruled out before
investigating other problems.   Exotic causes of this problem could be
storage problems or weird network issues (especially on windows).  But
locks need to be ruled out first.

merlin


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux