| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
| Cc: | catalin(at)plationline(dot)eu, 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-17 13:48:16 |
| Message-ID: | CAHyXU0ymioBrhaQNZvxmZDoD=--Lwn775VArbgRUbR8gFwbo5w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 16, 2016 at 6:55 PM, Melvin Davidson <melvin6925(at)gmail(dot)com> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2016-06-17 13:50:55 | Re: Question about RUM-index |
| Previous Message | Oleg Bartunov | 2016-06-17 13:47:08 | Re: Question about RUM-index |