Delay execution of SQL script in Amazon Redshift

Question

Does Redshift have any functions similar to pg_sleep() in PostgreSQL?

I have a SQL script that needs to wait for some time before continuing with the execution.

The Unsupported PostgreSQL Functions Redshift documentation that says pg_sleep() is not supported.

Update 1:

I am running into deadlock issue in Redshift. I have multiple processes that can query a table (or set of tables) with DROP/TRUNCATE/INSERT/UPDATE/SELECT. If there is a deadlock, I was trying to catch this exception and have the process wait for sometime and retry. Are there any recommendations on ways to handle deadlocks?

Does it just need to wait for a certain duration, or does it need to wait until some external event has (hopefully) happened? — John Rotenstein
– John Rotenstein, Commented Feb 22, 2017 at 23:24
Yeah, are you worried about eventual consistency or some similar case? — systemjack
– systemjack, Commented Feb 23, 2017 at 1:01
Forcing your script to wait is almost always the wrong thing to do - what is your use case i.e. why do you want to sleep? — saille
– saille, Commented Feb 23, 2017 at 4:21

systemjack · Accepted Answer · 2019-08-05 18:32:43Z

15

A sketchy not recommended approach is to use a Python User Defined Function:

CREATE OR REPLACE FUNCTION janky_sleep (x float) RETURNS bool IMMUTABLE as $$
    from time import sleep
    sleep(x)
    return True
$$ LANGUAGE plpythonu;

select janky_sleep(5.0);

edited Aug 5, 2019 at 18:32

answered Feb 23, 2017 at 1:10

systemjack

3,0051 gold badge21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rahul Gupta · Accepted Answer · 2017-02-24 20:38:25Z

0

Have you tried using lock on the table. I have had a similar situation like you, lock on the table helped me over come that.

answered Feb 24, 2017 at 20:38

Rahul Gupta

1,8022 gold badges18 silver badges30 bronze badges

1 Comment

einkleindatagal Over a year ago

How did you create that lock?

Collectives™ on Stack Overflow

Delay execution of SQL script in Amazon Redshift

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related