When Sigterm Does Nothing: A Postgres Mystery

  pg_usleep(1000L);

Virtually any time you put a fixed sleep in your program, it's going to be wrong. It is either too long or too short, and even if it is perfect, there is no guarantee your program will actually sleep for exactly the requested amount of time. A condition variable or something similar would be the right thing to use here.

Of course, if this code path really is only taken very infrequently, you can get away with it. But assumptions are not always right, it's better to make the code robust in all cases.

I was working through some ffmpeg timing stuff and the ai kept insisting on putting in sleep functions to try and "solve" it