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

2016-06-22 Thread Catalin Maftei
well, the for your reply, we have PG on linux ubuntu 14.04 distribution, but pls remember this issue started when our DB size increase to 3-5GB, now it is 16GB. this happend only when we use "CREATE OR REPLACE" since I can run a query and get reply a

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

2016-06-17 Thread Adrian Klaver
On 06/17/2016 09:01 AM, Catalin Maftei wrote: Please do not top post: https://en.wikipedia.org/wiki/Posting_style well, the for your reply, we have PG on linux ubuntu 14.04 distribution, but pls remember this issue started when our DB size increase to 3-5GB, now it is 16GB. See Merlins pos

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

2016-06-17 Thread Melvin Davidson
On Fri, Jun 17, 2016 at 12:01 PM, Catalin Maftei wrote: > well, > > the for your reply, > > we have PG on linux ubuntu 14.04 distribution, but pls remember this issue > started when our DB size increase to 3-5GB, now it is 16GB. > > this happend only when we use "*CREATE OR REPLACE"* > > > since

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

2016-06-17 Thread Merlin Moncure
On Thu, Jun 16, 2016 at 6:55 PM, Melvin Davidson 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

Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

2016-06-17 Thread Merlin Moncure
On Tue, Jun 14, 2016 at 4:59 PM, Catalin Maftei wrote: > when I recreate a VIEW or FUNCTION with a small change I get: > > Query returned successfully with no result in 03:58 minutes. This is almost certainly due to locks. Next time this happens, query pg_stat_activity and pg_locks -- the inform

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

2016-06-16 Thread Melvin Davidson
On Wed, Jun 15, 2016 at 12:49 AM, Catalin Maftei wrote: > hei Adrian, > > thx for your reply, > > this is an example: > > "CREATE OR REPLACE VIEW feedback.get_answers_set AS > SELECT f.awb || '/' || r.dulapid as "awb", > q.qid, > q.question, > a.aid, > a.answer, > q.questiona

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

2016-06-16 Thread Catalin Maftei
hei Adrian, thx for your reply, this is an example: "CREATE OR REPLACE VIEW feedback.get_answers_set AS SELECT f.awb || '/' || r.dulapid as "awb", q.qid, q.question, a.aid, a.answer, q.questionareid, f.stamp_created , c.first_name , l.referinta_expeditor FROM fe

Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

2016-06-15 Thread Melvin Davidson
On Wed, Jun 15, 2016 at 12:36 AM, Adrian Klaver 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 ru

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

2016-06-15 Thread Adrian Klaver
On 06/14/2016 09:49 PM, Catalin Maftei wrote: hei Adrian, thx for your reply, this is an example: "CREATE OR REPLACE VIEW feedback.get_answers_set AS SELECT f.awb || '/' || r.dulapid as "awb", q.qid, q.question, a.aid, a.answer, q.questionareid, f.stamp_created , c

Re: [GENERAL] random huge delay when recreate a VIEW or FUNCTION

2016-06-14 Thread Adrian Klaver
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 successful