Re: pg_sleep() inside plpgsql block - pro & cons

2018-10-02 Thread Laurenz Albe
pinker wrote: > Francisco Olarte wrote > > I do some similar things, but I sleep outside of the > > database, is there a reason this can not be done? > > > > Francisco Olarte. > > Yes, I do try to convince them to do it outside the db, that's the reason > I'm looking for some support here :) I'm

Re: pg_sleep() inside plpgsql block - pro & cons

2018-10-02 Thread Francisco Olarte
On Tue, Oct 2, 2018 at 3:44 PM, pinker wrote: ... > Yes, I do try to convince them to do it outside the db, that's the reason > I'm looking for some support here :) I'm not sure those 2 reasons are enough > to convince them, wanted to be prepared... Well, not knowing the logic I cannot be sure, b

Re: pg_sleep() inside plpgsql block - pro & cons

2018-10-02 Thread pinker
Francisco Olarte wrote > I do some similar things, but I sleep outside of the > database, is there a reason this can not be done? > > Francisco Olarte. Yes, I do try to convince them to do it outside the db, that's the reason I'm looking for some support here :) I'm not sure those 2 reasons are e

Re: pg_sleep() inside plpgsql block - pro & cons

2018-10-02 Thread Francisco Olarte
Hi: On Tue, Oct 2, 2018 at 12:10 PM, pinker wrote: > There is second time I see that somebody uses pg_sleep function inside > plpgsql block. This case is quite similar to the last one - it's some kind > of wait for data to be loaded. After pg_sleep there is a check if some > condition is true, if

pg_sleep() inside plpgsql block - pro & cons

2018-10-02 Thread pinker
Hi! There is second time I see that somebody uses pg_sleep function inside plpgsql block. This case is quite similar to the last one - it's some kind of wait for data to be loaded. After pg_sleep there is a check if some condition is true, if not procedure goes to sleep again. As a result an averag