Re: Hung Query with No Locking Issues

2023-05-08 Thread Michael P. McDonnell
Okay - that worked. How did you know that would work? That's incredible. On Sun, May 7, 2023 at 4:25 PM Tom Lane wrote: > "Michael P. McDonnell" writes: > > I have 2 stored procedures that need to run back to back. It could > > convert to a single one - but

Hung Query with No Locking Issues

2023-05-07 Thread Michael P. McDonnell
Hey team - I have 2 stored procedures that need to run back to back. It could convert to a single one - but it's easier from a maintenance perspective to keep them separated. The first procedure effectively is INSERT INTO table_b () SELECT FROM _table_a_; COMMIT; Total execution time - about